(SELECT colid
 FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = ''''PK''''))>0 then ''''√'''' else '''''''' end) N''''主键'''',
b.name N''''类型'''',
a.length N''''占用字节数'''',
COLUMNPROPERTY(a.id,a.name,''''PRECISION'''') as N''''长度'''',
isnull(COLUMNPROPERTY(a.id,a.name,''''Scale''''),0) as N''''小数位数'''',
(case when a.isnullable=1 then ''''√''''else '''''''' end) N''''允许空'''',
isnull(e.text,'''''''') N''''默认值'''',
isnull(g.[value],'''''''') AS N''''字段说明''''
--into ##tx
FROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
