Connector/Net Visual Studio Integration
1831
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 Up (to move the column up) or 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.
20.2.3.3.2. Editing Indexes
Indexes management is performed using the Indexes/Keys dialog.
To add an index, select Table Designer, Indexes/Keys... from the main menu, and click Add to add a
new index. You can then set the index name, index kind, index type, and a set of index columns.
Figure 20.9. Indexes Dialog
To remove an index, select it in the list box on the left, and click the Delete 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.
20.2.3.3.3. Editing Foreign Keys
You manage
foreign keys
for
InnoDB
tables using the Foreign Key Relationships dialog.
To add a foreign key, select Table Designer, Relationships... from the main menu. This displays the
Foreign Key Relationship dialog. Click Add. You can then set the foreign key name, referenced table
name, foreign key columns, and actions upon update and delete.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...