--查询系统汇总表名与其对应的列信息
SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S COLUMN NAME" FROM sysobjects a LEFT JOIN syscolumns b ON a.id = b.id
WHERE a.xtype = 'U' ORDER BY a.name
--oracle
SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S COLUMN NAME" FROM sysobjects a LEFT JOIN syscolumns b ON a.id = b.id
WHERE a.xtype = 'U' ORDER BY a.name