系统表/元数据/数据字典

蓝色底色的字为个人喜欢的名字，根据喜好进行修改

系统表/元数据/数据字典

系统表，也称元数据、数据字典

SELECT * FROM SYS.ALL_TABLES WHERE OWNER = 'USER' AND TABLE_NAME LIKE '%TEST_NAME%'

SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER = 'USER' AND TABLE_NAME LIKE '%TEST_NAME%'

SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER = 'USER' AND TABLE_NAME LIKE '%TEST_NAME%'

SELECT * FROM  SYS.ALL_CONS_COLUMNS WHERE OWNER = 'USER' AND TABLE_NAME LIKE '%TEST_NAME%'

SELECT * FROM  SYS.ALL_TAB_PARTITIONS WHERE OWNER = 'USER' AND TABLE_NAME LIKE '%TEST_NAME%'

SELECT * FROM SYS.ALL_SYNONYMS WHERE SYNONYM_NAME LIKE '%TEST_SYNONYM%'

SELECT * FROM SYS.ALL_USERS

SELECT * FROM SYS.ALL_SEQUENSE

SELECT * FROM SYS.DBA_DATA_FILES　　查看表空间的元数据

SELECT * FROM SYS.ALL_INDEXES WHERE TABLE_NAME LIKE '%TEST_NAME%'　　索引

SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_NAME LIKE '%TEST_NAME%'　　索引对应列

SELECT * FROM SYS.ALL_VIEWS WHERE  VIEW_NAME = 'TEST_VIEW'