我们如何确定两个SQL Server表之间的关系,无论是一对一还是其他关系.....?
我们如何确定两个SQL Server表之间的关系,无论是一对一还是其他关系.....?
您可以使用 Microsoft 系统视图来实现此目的:
SELECT
obj.name AS fk
,sch.name AS [schema_name]
,tabParent.name AS [table]
,colParent.name AS [column]
,tabRef.name AS [referenced_table]
,colRef.name AS [referenced_column]
FROM sys.foreign_key_columns fkc
JOIN sys.objects obj ON obj.object_id = fkc.constraint_object_id
JOIN sys.tables tabParent ON tabParent.object_id = fkc.parent_object_id
JOIN sys.schemas sch ON tabParent.schema_id = sch.schema_id
JOIN sys.columns colParent ON colParent.column_id = parent_column_id AND colParent.object_id = tabParent.object_id
JOIN sys.tables tabRef ON tabRef.object_id = fkc.referenced_object_id
JOIN sys.columns colRef ON colRef.column_id = referenced_column_id AND colRef.object_id = tabRef.object_id
JOIN sys.schemas schRef ON tabRef.schema_id = schRef.schema_id
WHERE schRef.name = N'dbo'
AND tabRef.name = N'Projects'