Shulou(Shulou.com)06/01 Report--

Sybase ASE comes with a command-line tool for exporting object structures: ddlgen

For more detailed usage, please refer to the definition syntax for extracting objects from the ASE database with DDLGEN

If the object structure contains Chinese, use the parameter:-Jcp936

The more practical uses are as follows:

1. Export the table structure (including indexes) of all tables in the database tpchdb:

Ddlgen-Usa-Psybase123456-STEST-Dtpchdb-TU-N%.%-Jcp936-O./tables.sql

2. Export the creation syntax of all views in the database tpchdb:

Ddlgen-Usa-Psybase123456-STEST-Dtpchdb-TV-N%.%-Jcp936-O./views.sql

3. Export the creation syntax of all stored procedures in the database tpchdb:

Ddlgen-Usa-Psybase123456-STEST-Dtpchdb-TP-N%.%-Jcp936-O./procs.sql

4. Export only the table structure (excluding the index):

Ddlgen-Usa-Psybase123456-STEST-Dtpchdb-TU-N%.%-FI-Jcp936-O./tables.sql

5. Just export the syntax of the index on the table:

Ddlgen-Usa-Psybase123456-STEST-Dtpchdb-TI-N%.%-Jcp936-O./indexes.sql

Note the common object types:

I-Index

U-table

TR-trigger

P-stored procedure

V-view

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.