I need to change(modify) comments in the table columns and comment to the table itself. How can I do it?
Is there something like alter table command, that can do it?
1 Answers
Simply run another comment command, e.g.
comment on table emp is 'List ofmployees';
comment on column emp.ename is 'Employee''s name';
as they will "overwrite" old comments.
Related