您好!您的问题是关于 SQL Server 2000 查询表的外键关系。
在 SQL Server 2000 中,可以使用以下查询来查找表的外键关系:
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) 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_object_id, fc.referenced_column_id) AS ReferenceColumnName
FROM sysforeignkeys AS f
INNER JOIN syscolumns AS fc
ON f.constid = fc.constid
WHERE OBJECT_NAME(f.parent_object_id) = 'TableName'
请将查询中的 'TableName' 替换为您要查询的表名。
这个查询将返回表的外键名称、表名、列名、引用表名和引用列名。
希望这个答案能够帮助您!
领取专属 10元无门槛券
手把手带您无忧上云