获取表名、字段类型、对应长度

SELECT

a.name 表名,

b.name 字段名,

c.name 字段类型,

c.length 字段长度

FROM

sysobjects a,

syscolumns b,

systypes c

WHERE

a.id = b.id

AND a.name = 'KQ_INFOS_METERING_SCHEME'

AND a.xtype = 'U'

AND b.xtype = c.xtype