Can somone provide a query that displays all tables that have Self Joins via RI defined?
select distinct SCHEMA_NAME(schema_id) As SchemaName, OBJECT_NAME(parent_object_id) As TableName
from sys.foreign_keys f
where parent_object_id = referenced_object_id
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?