Generating a DDL Script

Use Sybase Control Center to generate DDL to create a database or any of its objects.

Sybase Control Center includes an option that lets you generate DDL scripts for databases, tables, caches, devices, dump devices, segments, groups, roles, users, encryption keys, and compiled objects such as stored procedures, extended stored procedures, and functions.

  1. In the left pane of the Administration Console, expand ASE Servers, then select one of:
    • Compiled Objects
    • Schema Objects
    • Security
    • Space Management
  2. Select the database object for which to create DDL. For example, to obtain DDL for a specific stored procedure, select Procedures > Stored Procedures
    Sybase Control Center displays the list of all objects of the selected type defined in your Adaptive Server.
  3. Click in the Name field of the specific object for which you want the DDL script.
  4. Click the drop-down arrow, then select the option to generate DDL.
    You can save the DDL in an external file on your local file system.
Parent topic: Manage Encryption Keys