Table to View

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

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

Naming Rule: Displays any variables (relational model name or table name, or both in the specified order) that will be prefixed to the view name instead of V_. 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 table name is BOOKS: