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.name
select a.name as TableName,b.name as FieldName,c.text as defaultValuefrom sys.objects a inner join sys.columns b on a.object_id=b.object_id inner join sys.syscomments c on b.default_object_id=c.idorder by defaultValue
转载于:https://www.cnblogs.com/lfzwenzhu/p/3165081.html
