Modify definition of a table after the table being created¶
Modify Table Definition¶
- Click 'Table managemen' button in "Manage" screen, and then 'Table management' view is opened.
- Select table to change the table definition, and then right-click 'Edit table definition' menu.
Tip
Just CELF database (default) in 'Database to connect to' can change table definition.
- Change each field definition in 'Edit table' dialog.
Column Detail Table name You can change table name. Column name You can change column name. Column type You can change column type. Data is deleted after changing column type. Column location You can change column location. And also, you can change multiple columns. Add column You can add column. Delete column You can delete column. See also
Regarding each column of table setting, refer Create Table > Set Table Name And Column Name.
- Click 'Update table' button.
Attention
Be aware the following points when you change the table definition.
- Applications that refer to the table might not work after the change.
- If you change the column type, the data in that column will be deleted.
- The curent index setting will be removed.
Important
- To change table definitions, users require the following permissions.
- Application author
- Database administrator
And also, Application author needs below permission to tables.
- Administrator
- The rule of table name and column is along with MySQL specification basically.
- Available character:[0-9,a-z,A-Z$_] and U+0080 ..U+FFFF in Unicode
- 64 bytes or less than 64 bytes in UTF-8
- It is not allowed to create table name and column name just with number.
- It is not allowed to create table and column name with reserved name by MySQL.
Refer the detail of MySQL reference manual.
