 |
Glossary Item Box The Table Wizard allows you to create tables in a fast and convenient way, guiding you step by step through the process of defining table columns and properties. To run the wizard double-click the Create new table by using wizard item within the Profile Window | Tables page.
The first step in the Table Wizard allows you to set the name of the table and select its type. This type defines how MySQL stores and searches data in tables. Note, that to use MySQL foreign keys (diagram references) you should use the InnoDB table type. You can choose between MyISAM, InnoDB and others.
The next step of the wizard allows you to add columns for the table. The upper drop-down list contains a list of profile domains, which allow you to create a column with a set of predefined properties. The buttons below the column list are intended for managing the list: adding new columns, editing columns through the Edit Column dialog, or deleting the columns.
The Duplicate Column and the Lookup Column... items of the Add Column sub-menu allow you to add a new column identical to the selected one, and add a column as a part of a new relationship through the Insert Lookup Column dialog.
The third step of the Table Wizard is intended for tuning various table options: row format, table comment, etc. You can skip this step and keep the default properties in most cases.  To learn more about such table parameters, as row format, min/max rows and others, please refer to the Designing Table Options topic.
The final step of the wizard allows you to select the action to perform after the creation and displays information about the creation errors, if such occur.
Select Open the table in design mode to open the Table Designer after the table is created. To view and modify the data of the new table within the Grid Data View, select Open the table for entering data. To close the wizard without any action after creating the table, select the Take no action.
To start creating the table with all the parameters you have set, click the Finish button.
©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners. |
