Re: Tables with and without Primary key

On 11 Feb 2002 00:56:25 -0800, mkuruvil2000_at_yahoo.com (Jay) wrote:

>Could someone tell me how to list all the tables with Primary key set
>on them, and all tables without Primary key.
>
>Thanks in advance.

Tables with PK's :

select owner,table_name from dba_constraints where constraint_type ='P'

Regards,

Kenneth Koenraadt Received on Mon Feb 11 2002 - 03:18:31 CST