Table / column Comments [message #7389] |
Wed, 11 June 2003 03:09 |
Sachin Rananavare
Messages: 2 Registered: June 2003
|
Junior Member |
|
|
What script to be used while creating tables so that the comments are available in user_tab_comments and user_col_comments. Is it possible to add only commnets if the tables are already created.
|
|
|
Re: Table / column Comments [message #7390 is a reply to message #7389] |
Wed, 11 June 2003 03:51 |
Kavitha
Messages: 40 Registered: December 1999
|
Member |
|
|
Hi,
You can create comments using the COMMENT command:
COMMENT ON TABLE abc IS 'Test comment';
COMMENT ON COLUMN employees.job_id
IS 'abbreviated job title';
But the object needs to be on the database before you issue this statement.
Cheers
Kavitha
|
|
|