I can get the table comments from sys.user_tab_comments view.Where can I get the column comments?
Printable View
I can get the table comments from sys.user_tab_comments view.Where can I get the column comments?
SELECT * FROM ALL_COL_COMMENTS
Not to forget USER_COL_COMMENTS and DBA_COL_COMMENTS
thanks very much
Hi Ocean,
I can never remember where to find these things either, so I do something like:
Select column_name, owner, table_name
From all_tab_columns
Where column_name like '%COMMENT%'
and owner = 'SYS'
Order by column_name, owner, table_name;
That usually gives me a start . . . .