View to Table

Creates tables based on views in a selected relational model. This dialog is displayed if you click Tools, then View to Table Wizard.

The views in the selected relational model are displayed. Select all views or a subset, optionally specify any naming rule, and click Generate. A table is created for each selected view. Each table selects all columns from the view, although you can later modify the view definition as needed. By default (if no Naming Rule is specified), each table name is its associated view name, prefixed with T_. For example, if a view name is BOOKS, the associated table name by default will be T_BOOKS.

Naming Rule: Displays any variables (relational model name or view name, or both in the specified order) that will be prefixed to the table name instead of T_. To display a dialog box for selecting variables for the naming rule, click Add Variable. For example, assume that the relational model name is Library and the view name is BOOKS: