22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT T.name,
C.column_id,
C.name,
TP.name,
C.max_length,
C.precision,
C.scale
FROM sys.objects T
JOIN sys.columns C
ON C.object_id = T.object_id
JOIN sys.types TP
ON TP.user_type_id = C.user_type_id
WHERE T.type = 'U'
ORDER BY T.name, C.column_id
WITH T AS (SELECT * FROM sys.objects WHERE type='U')
,C AS (SELECT * FROM sys.columns)
,I AS (SELECT * FROM sys.indexes WHERE is_primary_key=1)
,IC AS (SELECT * FROM sys.index_columns)
SELECT T.name,
I.name,
C.name
FROM I
JOIN T
ON T.object_id = I.object_id
JOIN IC
ON IC.object_id = I.object_id
AND IC.index_id = I.index_id
JOIN C
ON C.object_id = IC.object_id
AND c.column_id = IC.column_id