DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Where can I get the column comments?

  1. #1
    Join Date
    Sep 2001
    Posts
    99

    Where can I get the column comments?

    I can get the table comments from sys.user_tab_comments view.Where can I get the column comments?
    ocean

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    SELECT * FROM ALL_COL_COMMENTS
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Not to forget USER_COL_COMMENTS and DBA_COL_COMMENTS
    Agasimani
    OCP(10g/9i/8i/8)

  4. #4
    Join Date
    Sep 2001
    Posts
    99

    thanks

    thanks very much
    ocean

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Hi Ocean,

    I can never remember where to find these things either, so I do something like:

    Select column_name, owner, table_name
    From all_tab_columns
    Where column_name like '%COMMENT%'
    and owner = 'SYS'
    Order by column_name, owner, table_name;


    That usually gives me a start . . . .
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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