DDL Gen Options

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

Table 1. 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. DDL for database
Property Description
Stored Procedures Generate DDL for stored procedures.
User Defined Functions Generate DDL for user-defined functions.
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. 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. 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. Sybase_ASE
Property Description
DDL for Database Generate the corresponding DDL for databases:
  • Defaults
  • Rules
  • Segments
  • INSTEAD OF Triggers
DDL for Table Generate the corresponding DDL for tables:
  • Triggers
  • Rules
  • Defaults
DDL for View Generate DDL for INSTEAD OF triggers.
Table 6. Sybase_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. 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

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com