Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Update comment in Oracle SQL

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?

like image 517
DY92 Avatar asked Aug 31 '26 11:08

DY92


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.

like image 138
Littlefoot Avatar answered Sep 03 '26 02:09

Littlefoot



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!