22,210
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp
SELECT t.name AS tableName,
c.name AS colName,
p.name AS typeName,
t.[object_id] AS table_objId,
c.column_id
INTO #tmp
FROM sys.tables AS t
INNER JOIN sys.[columns] AS c
ON t.[object_id] = c.[object_id]
INNER JOIN sys.types AS p
ON c.system_type_id = p.system_type_id
SELECT * FROM #tmp AS t LEFT JOIN sys.extended_properties AS ep ON t.table_objId=ep.major_id AND t.column_id = ep.minor_id
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp