表结构系统表

SELECT
a.name as COLUMN_NAME,
b.name as TYPE_NAME,
a.xprec as PRECISION,
a.xscale as SCALE,
a.length as LENGTH
FROM wgenius..syscolumns a, wgenius..systypes b
WHERE a.id = object_id('wgenius..WM_FND_LABEL_INFO') AND a.xtype = b.xtype