|
|
| Re: Cooment in Table [message #373218 is a reply to message #373216] |
Wed, 04 April 2001 12:35  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
comment on table t1 is 'This table''s name is T1';
comment on column t1.col1 is 'This column''s name is COL1';
select * from user_tab_comments where table_name = 'T1';
select * from user_col_comments where table_name = 'T1' and column_name = 'COL1';
-- To reset...
comment on table t1 is '';
-- To make a template script...
spool tab_comments.sql
select 'comment on table '||table_name||' is '''';' from user_tables;
spool off
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
