Forward Engineer/Alter Script › Forward Engineering/Schema Generation

Previous Topic: Validation Criteria for Teradata Models

Next Topic: Select Schema Generation Options (Forward Engineering)

Forward Engineering/Schema Generation

Forward engineering is the process of generating the physical database schema from a physical model. You use the Schema Generation dialog to forward engineer a model and generate the schema. The schema that you generate includes all options that are supported in your target server. You can customize the generated schema for your target server using features in the Schema Generation dialog.

Note: Advanced users can create custom schema generation options by editing the forward engineering template.

Before you generate the schema, you can check your model for potential problems with corrupt objects or other errors. You can run a validation report when you choose Check Model from the Actions, Forward Engineer menu.

Follow these steps to generate the schema:

  1. Select the schema generation options. For each option you select, the appropriate SQL statement is included in the DDL script, in the correct syntax for your target server.
  2. Review the schema generation options. The options appear in a hierarchical tree structure, and you can review each group of options individually by expanding or collapsing the tree. You can change any of the selected options and generate the correct SQL statements.
  3. Preview the schema DDL script. The schema DDL script is displayed based on the options you select. For example, if your target server is Oracle and you select the CREATE TABLE option, a CREATE TABLE statement is displayed for each selected table in the model.
  4. Change the schema generation options. At any time, you can change the schema generation options and generate the correct SQL statements.
  5. Generate the schema. When you generate the schema, you can connect to the target server and generate the schema, or you can generate an ASCII DDL script that you run as a separate step on the server to generate the schema. When you generate a DDL script, you can save it as a text file that you can open in a word-processing package or load it into a utility that interprets SQL scripts.

When the DDL script is executed, you can preview the results of each generated statement. When the DDL is successfully generated, you can change the statements and messages. You can search for text strings, cut, copy, and paste text to a message log, and save the message log to an ASCII text file or print it.

More information:

Alter Script/Schema Generation