Find the relationship difference between two DB. [sql] SELECT f.name AS ForeignKey FROM sys.foreign_keys AS f where f.name not in (SELECT f.name AS ForeignKey FROM… Read More »Find the Relationship Difference Between Two DB
find the relationships between tables in SQL Server 2008 [sql] SELECT f.name AS ForeignKey, SCHEMA_NAME(f.SCHEMA_ID) SchemaName, OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName, SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName, OBJECT_NAME… Read More »Find Relationships Between Tables in SQL Server 2008