Quick script to determine all foreign keys in your SQL Server database:SELECT f.name AS ForeignKey, OBJECT_NAME(f.parent_object... AS TableName, COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName, OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName, COL_NAME(fc.referenced_obje... fc.referenced_column_id) AS ReferenceColumnName ......