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_NAME = 'TABLE명'
AND COLUMN_NAME = 'COLUMN명' |
Table Comment 조회
SELECT *
FROM ALL_TAB_COMMENTS
WHERE TABLE_NAME = 'TABLE명' |
Column Comment 조회
SELECT *
FROM ALL_COL_COMMENTS
WHERE TABLE_NAME = 'TABLE명' |
