What's the best way to add a table description to a table in the metadata? Also, what about for each specific table as well? This is for an oracle Database.
When we use spy-schema to generate a schema I want to be able to show a description for each table and also a description of its columns.
Never-mind, I found my own answer:
Create a comment on a table
comment on table x is 'This is table x';
Create a comment on a column:
comment on column t.x is 'This is column X of table T';
to view these comments:
View Column comments
select * from user_col_comments where table_name = 'x';
View Table comment
select * from user_tab_comments where table_name = 'x';
Hopefully this helps someone else..