Namespaces are used to group sections of a design and can be used to selectively generate SQL for specific schemas in the data model. The generated SQL script supports SQL-99, Oracle, DB2, SQL Server, Sybase, Informix or InterBase formats. The Customize Code dialog is used to control whether SQL constructs are generated and specify the formatting and syntax used. Indexes can be generated for primary keys, alternate keys or generated from indexes defined in the data model. Some of the options is this dialog are only applicable to specific SQL dialects.
Some databases support several named object collections called schemas.
SQL code can be generated with or without schema prefixes using the Schema Syntax selection. The selected SQL dialect determines the format of the generate code. The Generate Code dialog has options to generate code for selected objects, all objects, physical models or objects within a namespace. If your project uses separate logical and physical diagrams, select the Physical Models option to generate code only for entity objects on physical models. An SQL Schema identifies a group of related objects such as Tables, Views, Constraints, Assertions, etc.