DDL Script Generation

The data models for the Sybase IQ and ASE databases target different databases; however, they share an almost identical structure. Modify data models by creating additional tables or columns to suit your business environment.

The ASE database schema must match the Sybase IQ schema for all tables in which data will be inserted. After you make changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the physical data model. PowerDesigner saves the DDL statements in a SQL script that you can run to generate the tables and other objects for the target databases.

PowerDesigner includes the DDL scripts to create database objects in both your ASE and Sybase IQ databases. You do not need to create or generate DDL scripts unless you customize the data models.

• Generating Database Schema with PowerDesigner
  PowerDesigner includes all the resources you need to generate a set of DDL statements in SQL scripts directly from the PowerDesigner data models. Run these scripts to generate a schema for your Sybase IQ and ASE databases.
• Generating DDL Scripts for the Sybase IQ Database
  Generate DDL for an Sybase IQ database. The data model for Sybase IQ is IQ.pdm.
• Generate DDL Scripts for the ASE Database
  The data model for an ASE database is ASE.pdm.