oracle table comment
SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'MY_TABLE'; -- Table comment SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'MY_TABLE'; -- Columns comments -- All owner tables: SELECT t.OWNER, t.TABLE_NAME, com.COMMENTS FROM DBA_TABLES t LEFT JOIN DBA_TAB_COMMENTS com ON com.OWNER = t.OWNER AND com.TABLE_NAME = t.TABLE_NAME WHERE t.OWNER = 'TRANSFERT_DOAAT' AND t.DROPPED = 'NO' ORDER BY t.OWNER, t.TABLE_NAME;
