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
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