hi all,
I have created a table with comments on the table but I want to remove/drop those comments....
help
Printable View
hi all,
I have created a table with comments on the table but I want to remove/drop those comments....
help
Just
That's two single-quotes.Code:comment on table my_table is ''
use:Quote:
Originally Posted by ndisang
COMMENT ON COLUMN tablename.comment_columnname IS ' ';
guys.....................please read the post first before replying OKKKKKKKKKKKKKKKKKKKKK...
I said I have the comments on the table already. What I want to do now is remove them (the comments)...
Thanks
Remove = replace with nothing?Quote:
Originally Posted by ndisang
Please, try the response before rejecting the concepts.
TO ALL,
Read the document before posting your query,
Give careful attention to detail before posting,
Try out the solution given by Expert DBA's,
Try the same before posting the solution,
Finally be patient enough to read the threads( all words) carefully.
dbtoo,Quote:
Originally Posted by dbtoo
I did not reject anything. If you read the responses the guys provided they are telling me how to create/add comments to a table/columns. But in my post (original) I said that I have already created/added those comments. What I was requesting for, was a sql to remove/delete them (comments).
Thanks.
Read the posts again. You need to try the suggested code. They are giving you the correct method to remove a comment. You set it to an empty string. If you don't believe them, look it up in the Oracle documentation...
HTML Code:http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_410a.htm#2060178
and then sort your attitude out
Amen.