SELECTCASEWHEN a.colorder =1THEN d.name ELSE''ENDAS 表名, a.colorder AS 字段序号, a.name AS 字段名, CASEWHENCOLUMNPROPERTY(a.id, a.name, 'IsIdentity') =1THEN'√'ELSE''ENDAS 标识, CASEWHENEXISTS (SELECT1 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''ENDAS 主键, b.name AS 类型, a.length AS 占用字节数, COLUMNPROPERTY(a.id, a.name, 'PRECISION') AS 长度, ISNULL(COLUMNPROPERTY(a.id, a.name, 'Scale'), 0) AS 小数位数, CASEWHEN a.isnullable =1THEN'√'ELSE''ENDAS 允许空, ISNULL(e.text, '') AS 默认值, ISNULL(g.[value], '') AS 字段说明 FROM syscolumns a LEFTOUTERJOIN systypes b ON a.xtype = b.xusertype INNERJOIN sysobjects d ON a.id = d.id AND d.xtype ='U'AND d.name <>'dtproperties'LEFTOUTERJOIN syscomments e ON a.cdefault = e.id LEFTOUTERJOIN sysproperties g ON a.id = g.id AND a.colid = g.smallid ORDERBY a.id, a.colorder
posted on
2007-04-16 16:33Caviare
阅读(202)
评论(0)
编辑收藏举报