Is there a table to select all the colomn names for any table???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Is there a table to select all the colomn names for any table???

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question

    Is there a table to select all the column names for any table???

    Thanks
    SM

    [Edited by supermega on 10-24-2000 at 11:48 AM]

  2. #2
    Join Date
    Aug 2000
    Posts
    53
    Hi supermega.

    If you are using TOAD, you can select a column name(not all columns) in all tables.

    Thanks
    ABC

  3. #3
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    select name from sys.col$;

    you must be either sys or have dba access.

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    DBA_TAB_COLUMNS, columns of all tables, views and clusters in the database.

  5. #5
    Join Date
    Jul 2000
    Posts
    7

    Cool

    Hi
    ALL_TAB_COLUMNS will also be able to fetch u the table_name and its column names.See if this is Ok for u

    Bye
    Vish M P

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