SqlServer查询字段属于哪个表
use EWMS_9_0_Prod--数据库名称 go 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= 'AC_Param_Sequence'--字段名