Home > Data Modeler Dialog Boxes > 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:
If you specify only view name, the name of the generated table will be BOOKS. That is, all tables will have the same name as their associated views.
If you specify only model name, the name of the generated table will be Library. You should probably not choose this option, because all tables will have names starting with the model name and jt1, jt2, and so on added to names after the first one.
If you specify model name and view name, the name of the generated table will be LibraryBOOKS.