Find tables without a Primary Key 1

[IanWaterman]

Is it possible to query a whole schema and find which tables if any do not have a primary Key.

Thank you

Ian

 

[Beilstwh]

Sure

select a.table_name
from user_tables A
where not exists
(select null
from user_constraints b
where a.table_name = b.table_name
and B.constraint_type='P');


Bill
Lead Application Developer
New York State, USA

 

[IanWaterman]

Exactly what I needed . Thank you