Dropping comment on a table command required!

Hi!

Working on Oracle v8i with NT as OS!

I had created a comment on table emp as below in scott schema:

SQL> COMMENT ON TABLE emp IS 'BRANCH_MASTER IS USED FOR MAINTAINING COMPANY BRANCH DETAILS';

Comment created.

Now,What is the command to drop the above comment form the emp table!

Regards,

Amit.

Did you try COMMENT ON TABLE emp IS '';

There is nothing like.. DROP COMMENT on table or so...

To drop a comment from the database, set it to the empty string ' '.


Sameer

Hi amit,

All comments for tables are stored in dba_tab_comments. But I don't know if it you could delete the row in that table ...

Cheers

Angel

Quote:

---

By arroyob
All comments for tables are stored in dba_tab_comments. But I don't know if it you could delete the row in that table ...

---

DBA_TAB_COMMENTS is a dictionary view and Oracle doesn't recommed to delete anything from dictionary except sys.aud$

HTH

Sanjay