列出表里字段的SQL语句

select obj.name N'表名',
col.name N'字段名',
(select top 1 name from systypes as types where types.xtype=col.xtype)N'数据类型',
(case when COLUMNPROPERTY( col.id,col.name,'IsIdentity')=1 then '√'else '' end) N'标识',
COLUMNPROPERTY(col.id,col.name,'PRECISION') as N'长度',
isnull(COLUMNPROPERTY(col.id,col.name,'Scale'),0) as N'小数位数',
(case when col.isnullable=1 then '√'else '' end) N'允许空',
(select com.text from syscomments as com where col.cdefault=com.id) N'默认值',
(select pro.value from sys.extended_properties as pro where pro.major_id=col.id and col.colid=pro.minor_id) N'字段说明'