Check if a table has self join

Question

Can somone provide a query that displays all tables that have Self Joins via RI defined?

Thanks!

---

GBM

Answer 1

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

Tom