Tuesday, March 2, 2010

Finding Child tables

We can find child tables of a table from the management studio as well as by the following query
select * from sys.foreign_keysselect object_name(parent_object_id), object_name(referenced_object_id)
from sys.foreign_keys

No comments:

Post a Comment