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.

The SQLSCHEMA utility accepts all encoding prefixes supported by the genpassword utility for encoding passwords before transmitting them over the network to the OpenEdge SQL server for authentication. If the password is provided in plain text, it is encoded using aedh0 before being transmitted over the network.

For more information, see genpassword and Encoding prefix.

Note: If the server is running a database of OpenEdge release 12.8 or earlier, it does not recognize the aedh0 encoding prefix and cannot decode passwords encoded with it. The connection fails with an error message.
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.