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
原文:https://www.cnblogs.com/gina11/p/14800446.html