Option
|
Description
|
---|---|
-c dir
|
Change working directory
|
-C catalog_name
|
Set the default catalog from where data definitions are read from or written to
|
-h, -?
|
Help = Usage
|
-m
|
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the console's locale/codepage, despite the settings in the server-side and client-side character data binding parameters.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the console's locale/codepage, despite the settings in the server-side and client-side character data binding parameters. Data in character data type columns is not converted.
|
-M locale_name
|
In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in the specified locale/codepage.
In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in the specified locale/codepage. Data in character data type columns is not converted.
The format of locale_name depends on the operating system.
For example, in Linux environments, the locale name for the code page GB18030 in Chinese/China is zh_CN.gb18030.
In Windows environments, the locale name for Latin1 code page in Finnish/Finland is fin_fin.1252.
|
-o filename
|
Write data definitions to this file
|
-O filename
|
Append data definitions to this file
|
-p
|
Preserve case of schema and table names
|
-s schema_name
|
List definitions from this schema only
|
-u
|
▪In Unicode databases (General.InternalCharEncoding=UTF8), expect the data in character and wide character data type columns to be encoded in UTF-8.
▪In partial Unicode databases (General.InternalCharEncoding=Raw), expect the data in wide character data type columns to be encoded in UTF-8. Data in character data type columns is not converted.
|
-x tableonly
|
List table definitions only
|
-x indexonly
|
List index definitions only
|
-x viewonly
|
List view definitions only
|
-x sequenceonly
|
List sequence definitions only
|
-x procedureonly
|
List procedure definitions only
|
-x publicationonly
|
List publication definitions only
|
-x eventonly
|
List event definitions only
|
-x triggeronly
|
List trigger definitions only
|
-x schemaonly
|
List schema definitions only
|
-x hiddennames
|
List internal constraint names only
|
-x pwdfile: filename
|
Read password from the file
|