Home » RDBMS Server » Server Administration » Cooment in Table
Cooment in Table [message #373216] Wed, 04 April 2001 10:09 Go to next message
Bobby
Messages: 32
Registered: August 2000
Member
How do i put a comment on a column in a table?

Report message to a moderator

Re: Cooment in Table [message #373218 is a reply to message #373216] Wed, 04 April 2001 12:35 Go to previous message
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

Report message to a moderator

Previous Topic: Re: LAST_UPDATED attribute
Next Topic: Urgent SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 01:24:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.