SQL常用系统信息语句

最新推荐文章于 2023-02-22 14:49:56 发布

转载最新推荐文章于 2023-02-22 14:49:56 发布 · 69 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/tx720/p/9102012.html

一.查询指定表外键约束

SELECT A.name AS 约束名 ,
        OBJECT_NAME(B.parent_object_id) AS 外键表 ,
        D.name AS 外键列 ,
        OBJECT_NAME(B.referenced_object_id) AS 主健表 ,
        C.name AS 主键列
FROM    sys.foreign_keys A
        INNER JOIN sys.foreign_key_columns B ON A.object_id = B.constraint_object_id
        INNER JOIN sys.columns C ON B.parent_object_id = C.object_id
                                    AND B.parent_column_id = C.column_id
        INNER JOIN sys.columns D ON B.referenced_object_id = D.object_id
                                    AND B.referenced_column_id = D.column_id
WHERE   OBJECT_NAME(B.referenced_object_id) = 'Position';

转载于:https://www.cnblogs.com/tx720/p/9102012.html