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

[supermega]

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]

[abc]

Hi supermega.

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

Thanks
ABC

[maachan]

select name from sys.col$;

you must be either sys or have dba access.

[akkerend]

DBA_TAB_COLUMNS, columns of all tables, views and clusters in the database.

[Vish_mp]

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