用sql语句查看表结构

SELECT B.NAME 字段名称,
	CASE WHEN C.NAME='bit' or C.NAME='int' or C.NAME='datetime' THEN C.NAME WHEN C.NAME='decimal' THEN C.NAME+'('+CAST(B.PREC AS varchar(50))+','+CAST(B.SCALE AS varchar(50))+')' 
	ELSE C.NAME+'('+CAST(B.PREC AS varchar(50))+')' END AS 字段类型,
    CONVERT(VARCHAR(1000),ISNULL(G.VALUE,'')) 字段说明
FROM SYSOBJECTS A INNER JOIN SYSCOLUMNS B ON A.ID=B.ID INNER JOIN SYSTYPES C ON B.XTYPE=C.XUSERTYPE
    LEFT JOIN SYSOBJECTS D ON B.ID=D.PARENT_OBJ AND D.XTYPE='PK'
    LEFT JOIN SYSINDEXES E ON B.ID=E.ID AND D.NAME=E.NAME
    LEFT JOIN SYSINDEXKEYS F ON B.ID=F.ID AND B.COLID=F.COLID AND E.INDID=F.INDID
    LEFT JOIN SYS.EXTENDED_PROPERTIES G ON B.ID=G.MAJOR_ID AND B.COLID=G.MINOR_ID
WHERE A.XTYPE='U' 
  AND OBJECT_NAME(B.ID) = 'FinishingEntry'--表名

运行结果