标签归档:dbschema

informix数据库下导出表结构

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.
继续阅读