SQLServer 2005 找db 所有欄位及屬性

use youDBName
GO
select * from sys.tables a inner join sys.columns b
on a.object_id = b.object_id left outer join sys.extended_properties c
on b.object_id = c.major_id and b.column_id = c.minor_id
and c.major_id > 0 left outer join sys.systypes d
on b.system_type_id = d.xtype
order by b.column_id
GO