不包括系统表和视图的其他的表的表名select tabname from systables where tabid99;查询除不包括系统的所有表，但是包括了视图select tabname from systables where tabid99 and tabtype='T';查询用户自己建的表select tabname from sysmaster:systabnames where dbsname='pmdb'导出数据Load导入数据执行命令 dbaccess test - -例如：导出全部数据unload to /opt/informix/abc.csv delimiter "," select * from test;导出前十行数据unload to /home/informix/ces.csv delimiter "," select first 10 * from ttq;/home/informix 为指定吐出数据文件csv 路径。导入数据