Find tables without a Primary Key 1

IanWaterman · Mar 8, 2017

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

Thank you

Ian

Beilstwh · Mar 9, 2017

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 · Mar 10, 2017

Exactly what I needed . Thank you

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Find tables without a Primary Key 1

IanWaterman

Programmer

Beilstwh

Programmer

IanWaterman

Programmer

Similar threads

Part and Inventory Search

Sponsor