find column names of all tables in a db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: find column names of all tables in a db

  1. #1
    Join Date
    Apr 2001
    Posts
    21
    How to find all the column name of all the tables in the database


    Thanks

  2. #2
    Join Date
    Sep 2000
    Posts
    47
    USER_TAB_COLUMNS

  3. #3
    Join Date
    Sep 2000
    Posts
    47
    Originally posted by Pinakin
    USER_TAB_COLUMNS
    or in ALL_TAB_COLUMNS for all tables of all users.

  4. #4
    Join Date
    Aug 2000
    Posts
    462
    For all the columns in the database, you'll need to log in as DBA and use all_tab_columns or dba_tab_columns.

    I ran:

    select count(*) from all_tab_columns;

    against a freshly installed personal Oracle 816 on Win98, logged in as a DBA, and I got:

    16410 rows.


    [Edited by kmesser on 05-03-2001 at 06:43 PM]

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Pinakin
    Originally posted by Pinakin
    USER_TAB_COLUMNS
    or in ALL_TAB_COLUMNS for all tables of all users.
    Better make it DBA_TAB_COLUMNS.

    USER_* - about objects you own
    ALL_* - about objects you have access to
    DBA_* - about all objects in the database (you have to have DBA privileges to use this)
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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