摘要： SELECT a.表名,a.字段名,a.类型和长度,a.可否为空,b.text as 默认值 from (select A.name as 表名,b.name as 字段名,c.name+ '( '+cast(b.length as varchar)+ ') ' as 类型和长度,b.isnullable as 可否未空,B.cdefault from sysobjects A ,syscolumns B,systypes C where A.xtype= 'u ' and a.id=b.id and B.xusertype=c.xusertyp 阅读全文