Re: DESCRIBE schema???

Systems and Programming <sysdev_at_adpsystems.mb.ca> wrote:
>Is there a command to describe the entire schema?
>It's easy to DESCRIBE table_name. But what is the
>command to describe the entire schema?
>
>I don't know if a similar command exists in Oracle,
>but I did this with Sybase when I was in university.
>

Hi there,

I am not sure whether a command really exists for describe schema. You can issue the following query against Oracle data dictionary.

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_SCALE, NULLABLE
FROM USER_TAB_COLUMNS
ORDER BY TABLE_NAME, COLUM_POSITION This will list you all the tables owned by that schema.

Hope the above answers your question

Regards

N.Prabhakar Received on Sat Dec 07 1996 - 00:00:00 CET