用于生成带有链接字段的数据库字典**的SQL脚本**

如果列涉及多个关系,则以下查询将复制该列。

Select C.TABLE_SCHEMA, C.TABLE_NAME, C.COLUMN_NAME, C.DATA_TYPE
    , PKCol.TABLE_SCHEMA, PKCol.TABLE_NAME, PKCol.COLUMN_NAME
From INFORMATION_SCHEMA.COLUMNS As C
    Left Join (INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE As FKCol
        Join INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS As FK
            On FK.CONSTRAINT_NAME = FKCol.CONSTRAINT_NAME
        Join INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE As PKCol
            On PKCol.CONSTRAINT_NAME = FK.UNIQUE_CONSTRAINT_NAME)
        On FKCol.TABLE_SCHEMA = C.TABLE_SCHEMA
            And FKCol.TABLE_NAME = C.TABLE_NAME
            ANd FKCol.COLUMN_NAME = C.COLUMN_NAME