Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

list of table with no constraint

007Jan 24 2011 — edited Jan 24 2011

hi,

i want to get the list of table which does not have primary key from a list of 100 tables. i am using the user_constraints table with the 100 tables list in WHERE clause for getting the list,but there are about 20 tables with no constraints on it . So that those table is not included in the user_constraints. Can anyone help me in getting the sql query to retrive the list of tables with no primary key along with the tables that dont have any constraint on it?????????

thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2011

Added on Jan 24 2011

#general-database-discussions

5 comments

487 views