Tags: orphans, programming, relationships, script, searching, sql, tables, write
A script to check for orphans
Hello - I'm using sql 2005 and I am searching for a way to write a sql script
that could check the relationships between all tables in a database and
return results of if there are any child or parent orphans.
Is there a system stored procedure that would return results of all tables
and their PK - FK relationships that I may be able to use to write this
script? or even something that may already exist that does what I'm trying to
Leave a comment...
- 0 Comments