DDL Gen Options

Set these preferences to specify defaults for generating data definition language (DDL).

Table 1. Generate DDL preferences: generate options
Property Description
CREATE Statements Generate DDL with a create statement.
DROP Statements Generate DDL with a drop statement.
Fully Qualified Name Generate DDL with fully qualified names.
Quoted Identifier Generate DDL with the quoted identifier style.
Grant Privilege Statements Generate DDL with statements for granting permissions.
Table 2. Generate DDL preferences: DDL for database
Property Description
Stored Procedures Generate DDL for stored procedures.
Tables Generate DDL for tables.
Proxy Tables Generate DDL for proxy tables.
Views Generate DDL for views.
User Defined Types Generate DDL for user-defined types.
Indexes Generate DDL for indexes.
Triggers Generate DDL for triggers.
Users and Groups Generate DDL for users and groups.
Table 3. Generate DDL preferences: DDL for table
Property Description
Primary Key Constraint Generate DDL for a primary key constraint.
Unique Constraints Generate DDL for unique key constraints on tables.
Foreign Keys Generate DDL for foreign key constraints on tables.
Check Constraints Generate DDL for table check constraints.
Indexes Generate DDL for indexes.
User Defined Types Generate DDL for user-defined types.
Table 4. Generate DDL preferences: others
Property Description
Execute Immediately Immediately execute the DDL on the data server.
Generate Script Generate the DDL script and open it in the SQL Editor.
Generate Full Hierarchy Generate full hierarchies.
Table 5. Generate DDL preferences: ASE
Property Description
DDL for Database Generate the corresponding DDL for databases:
  • Defaults
  • Rules
  • Segments
DDL for Table Generate the corresponding DDL for tables:
  • Triggers
  • Rules
  • Defaults
Table 6. Generate DDL preferences: ASA
Property Description
DDL for Database Generate the corresponding DDL for databases:
  • User-defined functions
  • Events
  • Dbspace
DDL for Table Generate the corresponding DDL for tables:
  • Triggers
Table 7. Generate DDL preferences: Sybase IQ
Property Description
DDL for Database Generate the corresponding DDL for databases:
  • User-defined functions
  • Events
  • Dbspace
Parent topic: Setting Database Development Preferences
Related concepts
Data Definition Language Generation
Related tasks
Generating Data Definition Language
Viewing the Database Definition Language for a Table

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com