Dropping comment on a table command required!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Dropping comment on a table command required!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Did you try COMMENT ON TABLE emp IS '';
    -- Dilip

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    There is nothing like.. DROP COMMENT on table or so...

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


    Sameer

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  


Click Here to Expand Forum to Full Width