Re: Help with the describe command.

michael.forman_at_tallan.com (Michael Forman) wrote in <86ngok01jmk_at_enews5.newsguy.com>:

>Can someone refresh my memory on how to get SQL+ to give me a listing of
all my table names?

select table_name from user_tables;

>Also, when I do a
>DESCRIBE XXX
>how can I tell what column(s) is the primary key?

they will always be NOT NULL. normally the primary keys are found among the table constraints view USER_CONSTRAINT_COLS.

-- 
dave mausner