Connector/Net contains a table editor, which enables the visual creation and modification of tables.
The Table Designer can be accessed through a mouse action on table-type node of Server Explorer. To create a new table, right-click the Tables node (under the connection node) and choose the command from the context menu.
To modify an existing table, double-click the node of the table to modify, or right-click this node and choose the item from the context menu. Either of the commands opens the Table Designer.
The table editor is implemented in the manner of the well-known Query Browser Table Editor, but with minor differences.
Table Designer consists of the following parts:
Columns Editor - a data grid on top of the Table Designer. Use the Columns grid for column creation, modification, and deletion.
Indexes tab - a tab on bottom of the Table Designer. Use the Indexes tab for indexes management.
Foreign Keys tab - a tab on bottom of the Table Designer. Use the Foreign Keys tab for foreign keys management.
Column Details tab - a tab on bottom of the Table Designer. Use the Column Details tab to set advanced column options.
Properties window - a standard Visual Studio Properties window, where the properties of the edited table are displayed. Use the Properties window to set the table properties.
Each of these areas is discussed in more detail in subsequent sections.
To save changes you have made in the Table Designer, use either or button of the Visual Studio main toolbar, or press Control+S. If you have not already named the table, you will be prompted to do so.
Once the table is created, you can view it in the Server Explorer.
The Table Designer main menu lets you set a primary key column, edit relationships such as foreign keys, and create indexes.
You can use the Column Editor to set or change the name, data type, default value, and other properties of a table column. To set the focus to a needed cell of a grid, use the mouse click. Also you can move through the grid using Tab and Shift+Tab keys.
To set or change the name, data type, default value and comment of a column, activate the appropriate cell and type the desired value.
To set or unset flag-type column properties (NOT
NULL, auto incremented, flags), check or uncheck the
corresponding check boxes. Note that the set of column flags
depends on its data type.
To reorder columns, index columns or foreign key columns in the Column Editor, select the whole column to reorder by clicking the selector column on the left of the column grid. Then move the column by using Control+Up (to move the column up) or Control+Down (to move the column down) keys.
To delete a column, select it by clicking the selector column on the left of the column grid, then press the Delete button on a keyboard.
Indexes management is performed using the Indexes/Keys dialog.
To add an index, select , from the main menu, and click to add a new index. You can then set the index name, index kind, index type, and a set of index columns.
To remove an index, select it in the list box on the left, and click the button.
To change index settings, select the needed index in the list box on the left. The detailed information about the index is displayed in the panel on the right hand side. Change the desired values.
You manage foreign keys
for InnoDB tables using the
Foreign Key Relationships dialog.
To add a foreign key, select , from the main menu. This displays the Foreign Key Relationship dialog. Click . You can then set the foreign key name, referenced table name, foreign key columns, and actions upon update and delete.
To remove a foreign key, select it in the list box on the left, and click the button.
To change foreign key settings, select the required foreign key in the list box on the left. The detailed information about the foreign key is displayed in the right hand panel. Change the desired values.
The Column Properties tab can be used to set column options. In addition to the general column properties presented in the Column Editor, in the Column Properties tab you can set additional properties such as Character Set, Collation and Precision.
To bring up Table Properties select the table and right-click to activate the context menu. Select . The Table Properties dockable window will be displayed.
The following table properties can be set:
Auto Increment.
Average Row Length.
Character Set.
Collation.
Comment.
Data Directory.
Index Directory.
Maximum Rows.
Minimum Rows.
Name.
Row Format.
Schema.
Storage Engine. Note that in MySQL 5.5 and higher, the default storage engine for new tables is
InnoDB. See Section 14.2.1.1, “InnoDBas the Default MySQL Storage Engine” for more information about the choice of storage engine, and considerations if you convert existing tables toInnoDB.
The property Schema is read-only.
User Comments
Add your own comment.