informix数据库下导出表结构
关键字: dbschema工具
[informix@datacenter ~]$ dbschema -?
USAGE:
dbschema [-t tabname] [-s user] [-p user] [-r rolename] [-f procname]
[-hd tabname] -d dbname [-ss] [filename]
-t table name or "all" for all tables
-s synonyms created by user name
or "all" for all users
-ss generate server specific syntax
-p permissions granted to user name
or "all" for all users
-r create and grant of the role
or "all" for all roles :Not a valid option for SE
-f SPL routine name
or "all" for all SPL routines
-d database name
filename is the name
of file that the SQL
script goes in.
-hd Histograms of the distribution for columns of
of a specified table, a specific table column,
or "all" for all tables. 继续阅读