Column List

SELECT C.TABLE_NAME, C.COLUMN_NAME, C.DATA_TYPE, C.CHARACTER_MAXIMUM_LENGTH, C.NUMERIC_PRECISION, C.IS_NULLABLE, TC.CONSTRAINT_NAME

FROM INFORMATION_SCHEMA.COLUMNS AS C

    LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC

      ON TC.TABLE_SCHEMA = C.TABLE_SCHEMA

          AND TC.TABLE_NAME = C.TABLE_NAME

          AND TC.CONSTRAINT_TYPE = 'PRIMARY KEY'

ORDER BY C.TABLE_NAME