摘要： select a.name as TableName,b.name as FieldName,c.text as defaultValuefrom sys.sysobjects a inner join sys.syscolumns b on a.id=b.id inner join sys.syscomments c on b.cdefault=c.idwhere a.xtype='U'order by a.name,b.nameselect a.name as TableName,b.name as FieldName,c.text as defaultValuefrom 阅读全文