Where can I get the column comments?

[oceanju]

I can get the table comments from sys.user_tab_comments view.Where can I get the column comments?

[grjohnson]

SELECT * FROM ALL_COL_COMMENTS

[agasimani]

Not to forget USER_COL_COMMENTS and DBA_COL_COMMENTS

[oceanju]

thanks very much

[DaPi]

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 . . . .