Duplicate the Definition of the Created Table

Duplicate table definition

1. Click 'Table management' in "Manage" screen, and then 'Table management' view is opened.

2. Right-click the table you want to duplicate from 'List of tables' and click the 'Copy table definition' menu.

3. In the 'Create table' dialog, change the table name and column definition and click the 'Create table' button.

Tip

You can duplicate tables only if the database you connect to is 'CELF database (default)'.

Important

1. To duplicate table definitions, users require the following permissions.

• Application author
• Database administrator

And also, Application author needs below permission to tables.

• Administrator
• Edit
• Read

2. 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.

Related keywords

copy