-
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.
Oracle DBA (OCP) v8i,v9i
-
Did you try COMMENT ON TABLE emp IS '';
-- Dilip
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|