查看SQLSERVER 表结构
需积分: 50 128 浏览量
2012-03-23
10:09:48
上传
评论
收藏 14KB DOCX 举报
Select
表名=Case When A.ColOrder=1 Then D.Name Else '' End,
字段序号=A.ColOrder,
字段名=A.Name,
标识=Case When COLUMNPROPERTY( A.ID,A.Name,'IsIden$ty')=1 Then '√'Else '' End,
主键=Case When exists(Select 1 From sysobjects where Xtype='PK' And Name In (
Select Name From sysindexes Where indid In(
Select indid From sysindexkeys Where ID = A.ID AND colid=A.colid
))) Then '√' Else '' End,
类型=B.Name,
占用字节数=A.length,
长度=COLUMNPROPERTY(A.ID,A.Name,'PRECISION'),
小数位数=IsNull(COLUMNPROPERTY(A.ID,A.Name,'Scale'),0),
允许空=Case When A.isnullable=1 Then '√'Else '' End,
默认值=IsNull(E.text,''),
字段说明=IsNull(G.[value],'')
From syscolumns A
Le: Join systypes B On A.Xtype=B.xusertype
Inner Join sysobjects D On A.ID=D.ID And D.Xtype='U' And D.Name<>'dtproper$es'
Le: Join syscomments E On A.cdefault=E.ID
Le: Join sys.extended_proper$es G On A.colid=G.minor_id and a.id=g.major_id
Where D.Name='RES_RMA_PN_Detail'
Order By A.ID,A.ColOrder
资源评论
