OBJECT 조회 SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'OBJECT명' TABLE 조회 SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE 'TABLE명' SYNONYM 조회 SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'SYNONYM명' TABLE INDEX 조회 SELECT * FROM ALL_IND_COLUMNS WHERE TAVBLE_NAME = 'TABLE명' TABLE Column 조회 SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE명' SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NA..
[Oracle] 테이블 정보 조회
OBJECT 조회 SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'OBJECT명' TABLE 조회 SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE 'TABLE명' SYNONYM 조회 SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'SYNONYM명' TABLE INDEX 조회 SELECT * FROM ALL_IND_COLUMNS WHERE TAVBLE_NAME = 'TABLE명' TABLE Column 조회 SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE명' SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NA..
2022.08.10