-
Hi,
I need to know which are tables does not have relationship between primary key and foreign key table
Plz let me know,
Regards,
G.shankar.
-
Could you please reformulate your question?
-
If you're looking for tables whithout any primary and froeign key constraints then....
select tname from tab where tname not in(select table_name from dba_constraints where constraint_type in('P','R'));
I hope I've got your question correctly.
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|