Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Schema Properties › Define SQL Azure Schema Generation Schema Options

Define SQL Azure Schema Generation Schema Options

You can define SQL Azure schema options using the Options tab of the Forward Engineer Schema Generation dialog that are appropriate for your modeling environment.

To define schema generation schema options

1. Click Forward Engineer, Schema... on the Actions menu.

   The Forward Engineer Schema Generation dialog opens on the Options tab.

2. Select the name of the current option set and make your selections to include statements and actions in the generated schema using the following options:
   • Security—Includes CREATE LOGIN or DROP LOGIN statements.
   • Database
     • Includes CREATE statements for DATABASE, SCHEMA, DATABASE ROLE, USER ID
     • Includes DROP statements for SCHEMA, DATABASE ROLE, USER ID
   • Schema
     • Includes prescripts to execute before generating the schema, and postscripts to execute after generating the schema.
     • Includes CREATE statements for FUNCTION, PROCEDURE, USER DEFINED TYPE, SYNONYM
     • Includes DROP statements for FUNCTION, PROCEDURE, USER DEFINED TYPE, SYNONYM
   • Table
     • Includes prescripts to execute before generating the table, and postscripts to execute after generating the table.
     • Includes CREATE statements for TABLE, PROCEDURE, FUNCTION, TABLE VALIDATION. TABLE VALIDATION includes statements for CREATE and ALTER.
     • Includes DROP statements for TABLE, PROCEDURE, FUNCTION
   • Column
     • Includes CREATE statements for VALIDATION, DEFAULT
     • Includes ALTER statements for VALIDATION, DEFAULT
     • Includes statements for PHYSICAL ORDER and USER DATATYPE
   • View
     • Includes prescripts to execute before generating the view, and postscripts to execute after generating the view.
     • Includes CREATE statements for VIEW, PROCEDURE, FUNCTION
     • Includes DROP statements for VIEW, PROCEDURE, FUNCTION
   • Index
     • Includes CREATE statements for INDEX. CREATE INDEX includes statements for TABLE INDEX and VIEW INDEX.
     • Includes DROP statements for INDEX. DROP INDEX includes statements for TABLE INDEX and VIEW INDEX.
   • Referential Integrity
     • Includes statements for PRIMARY KEY (PK), FOREIGN KEY (FK), UNIQUE (AK)
   • Trigger
     • Includes statements for ERWIN GENERATED and USER DEFINED
     • Includes CREATE statements for TRIGGER. CREATE TRIGGER includes statements for TABLE, VIEW, DATABASE triggers.
     • Includes DROP statements for TRIGGER. DROP TRIGGER includes statements for TABLE, VIEW, DATABASE triggers.
   • Other Options
     • Includes statements for CONSTRAINT NAME, SCHEMA, PERMISSION, GENERATE PASSWORDS, DELIMIT IDENTIFIERS, N QUOTED STRING, RUN CHECK MODEL
3. Click Generate to start the schema generation process for forward engineering or alter script generation or OK to save the changes and close the dialog.