SQLSCHEMA

SQLSCHEMA is a command-line utility that writes selected components of an SQL database schema to an output file using the UTF-8 code page. You might then use SQL Explorer to load the schema components into an SQL database The syntax for SQLSCHEMA (for UNIX and Windows) is:

sqlschema -u username -a password -t table-name[,table-name...]database-url[-g table-list...][-o output-filename][-p procedure-list][-s synonym-list][-T trigger-list]

username, password

User authentication.

table-name [,table-name...]

Table schemas to dump. Multiple tables can be specified, in a comma-separated list. Specify a table of % to load all tables. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

database-url

The database to which you want to connect, which has the following form:

progress:T:host-name:service-name:database-name

table-list

Comma-separated list of one or more grant privileges to dump as grant statements. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

output-filename

The file to which schemas are dumped. The default is screen.

procedure-list

Comma-separated list of one or more procedures for which to capture definitions. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

synonym-list

Comma-separated list of one or more synonyms to dump as create synonym statements. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.

trigger-list

Comma-separated list of triggers for which to capture definitions. The syntax supports the % (percent) and _ (underscore) special characters and the \ (backslash) escape character.