テーブル定義取得
SELECT SO.TYPE ,SO.NAME ,SC.NAME ,case SC.isnullable when 1 then '' ELSE 'NOT NULL' end ,ST.name ,SC.length FROM syscolumns SC JOIN sysobjects SO ON SC.ID = SO.ID JOIN sysusers SU ON SO.UID = SU.UID JOIN systypes ST ON SC.xtype = ST.xtype WHERE SO.TYPE IN('U', 'IF', 'TF', 'V', 'P') AND SO.STATUS >= 0 ORDER BY SO.NAME