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'