Where can I get the column comments?
I can get the table comments from sys.user_tab_comments view.Where can I get the column comments?
SELECT * FROM ALL_COL_COMMENTS
OCP 8i, 9i DBA
Not to forget USER_COL_COMMENTS and DBA_COL_COMMENTS
I can never remember where to find these things either, so I do something like:
Select column_name, owner, table_name
Where column_name like '%COMMENT%'
and owner = 'SYS'
Order by column_name, owner, table_name;
That usually gives me a start . . . .
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Click Here to Expand Forum to Full Width