1 select a.name as [column],b.name,a.length as type2 from syscolumns a,systypes b3 where a.id=object_id('表名') and a.xtype=b.xtype

select syscolumns.name as 字段名,systypes.name as 数据类型,syscolumns.length as 长度 from syscolumns  join systypes on systypes.xtype=syscolumns.xtypewhere id=(select id from sysobjects where  name='表名')