SQL Script To Generate a Database Dictionary **With Linked Fields**

Answer 1

The following query will duplicate a column if it is involved in more than one relationship.

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