分享：取出表结构信息，便于整理数据字典(SQL2005版)

[beatify]

以下例子，取出数据表中包含contact的结构信息
包括表名，列名，数据类型，长度，是否允许空，是否自动编号

select a.name as tablename
,b.name as columnname
,c.name as datatype
,b.max_length
,b.is_nullable
,b.is_identity
,d.value as description
from sys.all_objects a
inner join
sys.columns b
on a.object_id=b.object_id
inner join
sys.types c
on b.system_type_id=c.system_type_id
inner join
sys.extended_properties d
on b.object_id=d.major_id
and b.column_id=d.minor_id
where d.class=1
and c.name <>'sysname'
and a.name like'contact%'
order by a.name