How to get the table and column names?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to get the table and column names?

  1. #1
    Join Date
    Apr 2001
    Posts
    13

    Question

    Hi!

    How can I get an Oracle database to tell me the names of it's tables? What about the names of the columns in a table?

    Thanks!

  2. #2
    Join Date
    Apr 2001
    Posts
    10
    Please logon to the database as SYSTEM

    -- To check all object names, owner, object_type, status
    select *
    from dba_objects
    /

    -- To check column name, table_name,owner
    select *
    from dba_tab_columns
    /



    Hope this helps.



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