remove/drop comments from table

[ndisang]

hi all,
I have created a table with comments on the table but I want to remove/drop those comments....
help

[slimdave]

Just

comment on table my_table is ''

That's two single-quotes.

[dbasan]

hi all,
I have created a table with comments on the table but I want to remove/drop those comments....
help

use:

COMMENT ON COLUMN tablename.comment_columnname IS ' ';

[ndisang]

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

[dbtoo]

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?

Please, try the response before rejecting the concepts.

[dbasan]

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.

[ndisang]

Remove = replace with nothing?

Please, try the response before rejecting the concepts.

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.

[wdfloyd]

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...

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_410a.htm#2060178

[davey23uk]

and then sort your attitude out

[Horace]

Amen.