SQLServer 查询字段在哪些表里
2019/12/31
SELECT
表名 = D.name ,
字段序号 = A.colorder,
字段名 = A.name,
类型 = B.name,
字段说明=isnull(g.[value],'')
FROM syscolumns A
LEFT JOIN systypes B ON A.xusertype=B.xusertype
INNER JOIN sysobjects D ON A.id=D.id and D.xtype='U' and D.name<>'dtproperties'
LEFT JOIN sys.extended_properties G ON a.id=g.major_id and a.colid=g.minor_id
WHERE A.name= 'ProductID'--字段名·