Sybase table Structure Export method

Sybase ASE comes with a command-line tool that exports an object structure: Ddlgen

For more detailed usage, refer to: Extracting the definition syntax for an object from an ASE database using Ddlgen

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

A more practical use is 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 for all views within the database tpchdb:

ddlgen-usa-psybase123456-stest-dtpchdb-tv-n%.%-jcp936-o./views.sql

3. Export the creation syntax for all stored procedures within the database tpchdb:

ddlgen-usa-psybase123456-stest-dtpchdb-tp-n%.%-jcp936-o./procs.sql

4. Export only the table structure (does not include the index):

ddlgen-usa-psybase123456-stest-dtpchdb-tu-n%.%-fi-jcp936-o./tables.sql

5. Simply 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

Sybase table Structure Export method