(SELECT colid FROM syscolumns WHERE (id = a.id) AND (name = a.name))))))) AND (xtype =''''PK''''))>0then''''√''''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''''小数位数'''', (casewhen a.isnullable=1then''''√''''else''''''''end) N''''允许空'''', isnull(e.text,'''''''') N''''默认值'''', isnull(g.[value],'''''''') AS N''''字段说明'''' --into ##tx FROM syscolumns a leftjoin systypes b on a.xtype=b.xusertype innerjoin sysobjects d