How to describe all tables in a schema

[m2001331]

Hi,
I would like to know if there are any methods to describe tables in a schema using one sql command, instead of doing desc 1,desc 2....desc n?
I would appreciate it if anyone could advise on this.I have a schema with over 200 tables and would really love to save sometime by avoiding to describe each and every table one by one.

thanks and regards.

 

[R1972]

SELECT TABLE_NAME, COLUMN_NAME FROM USER_TAB_COLUMNS

IF U WANT TO KNOW ABT THE CONSTRAINTS USE COMBINATION OF THE dictionary tables like user_tables, user_tab_columns, user_constraints, user_cons_columns

 

[sem]

break on table_name

select table_name, column_name
, DECODE(nullable,'Y','','NOT NULL')
from user_tab_columns
order by table_name, column_id


Regards, Dima

 

[ddrillich]

Dima,

I would add the data type as well.

select table_name, column_name, data_type,
DECODE(nullable,'Y',' ','NOT NULL') as "Null?"
from user_tab_columns
order by table_name, column_id

Dan

 

[sem]

Once upon a time I wrote a script combining user_tab_columns, user_tab_comments and user_col_comments and called it desc. Thus calling @desc <table> provided more complete table description. With todays GUI tools it worths about nothing

Regards, Dima