select a.name as TableName,b.name as FieldName,c.text as defaultValue
from sys.sysobjects a inner join sys.syscolumns b on a.id=b.id
inner join sys.syscomments c on b.cdefault=c.id
where a.xtype='U'
order by a.name,b.name
select a.name as TableName,b.name as FieldName,c.text as defaultValue
from 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.id
order by defaultValue
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。