---

sql 查询某个表的字段信息（包括备注说明）

---

sql 查询某个表的字段信息（包括备注说明）

 

______________________________________

sql2005

select sys.columns.name,sys.columns.max_length,sys.Types.name,sys.columns.is_nullable,sys.extended_properties.value

from sys.columns  

left join sys.extended_properties

on sys.extended_properties.major_id=sys.columns.object_id and sys.extended_properties.minor_id=sys.columns.column_id

left join sys.Types on sys.Types.system_type_id=sys.columns.system_type_id

where object_id=(select top 1 object_id from sys.tables where name =@tableName)

 

______________________________

sql2000

select syscolumns.name,syscolumns.length,sysTypes.name,syscolumns.isnullable,sysproperties.value

from syscolumns

left join sysproperties

on sysproperties.smallid=syscolumns.colid

and sysproperties.id=syscolumns.id

left join sysTypes on sysTypes.xtype=syscolumns.xtype

where syscolumns.id=(select top 1 id from sysobjects where name ='@tableName')

---