add comment to table creation script(urgent)

[dragon99]

Hi, all
How do I add a comment to a table creation script after the table has been created. I tried
SQL> alter table TABLENAME add comment on ....
and it did not work. Any help would be appreciated.

dragon

[sukimac]

COMMENT ON TABLE schema.table_name IS
'This table holds attributes of a product.';

[raghucharan]

COMMENT ON TABLE tablename 'YOUR COMMENTS';

[dragon99]

Thanks for timely response.

[dragon99]

Sukimac is correct.

[raghucharan]

Sorry missed 'IS'

Raghu

[dragon99]

I am sorry I did not make clear before, my developer wants to put comment on column, I need the syntax for comment on column not just on table. Thanks again for help.

[akkerend]

COMMENT ON COLUMN tablename.columnname IS 'your comment';

[dragon99]

Thanks to all!