查看数据库中表和列名数据类型
SELECT字段名=a.Name,类型=B.Name,长度=COLUMNPROPERTY(a.ID,a.Name,'PRECISION'),字段说明=IsNull(G.[value],'')FROM syscolumns aleft join systypes B On a.Xtype=B.xusertypeleft join sysproperties G On a.ID=G.ID And a.colid=G.smallidWhere a.id=object_id('要查询的表') --如果只查询指定表,加上此条件order by a.ID,a.colorder??
