Other Tasks
Generally speaking, the "Other Tasks" are batch-like tasks that work on all tables of a database.
- Create Database Only
Entering a name into 'New Database Name' textfield will always generate a CREATE DATABASE statement. Selecting the 'Create Database Only' button means that only the CREATE DATABASE statement is generated. - Drop Database
This option will generate a DROP DATABASE statement for every schema selected in the 'Scope' tab. - Duplicate Objects of Database
This option uses the 'Append Text' textfield and the 'Duplicate Data' checkbox to the right of the radio buttons. This option will generate a CREATE TABLE LIKE statement for every table in the selected database(s). The new table name will have the 'Append Text' string added to its name. If the 'Duplicate Data' checkbox is checked, then the CREATE TABLE LIKE statement is followed by an INSERT-SELECT statement.Note that the CREATE TABLE LIKE statement will duplicate the table structure, but will not duplicate indexes. It could also potentially generate a very large script; generating may take a few moments.
- Duplicate Selected
This option works like the above 'Duplicate Objects of Database' option, but will only work on the selected table. - Drop Selected
This option drops the selected table from the schemas selected in the 'Scope' tab. - Truncate Selected
This option truncates the selected tables from the schemas selected in the 'Scope' tab. - Check Table
This option runs CHECK TABLE against the selected table from the schemas selected in the 'Scope' tab. - Create Table
This option displays the result of a SHOW CREATE TABLE command on the selected table from current schemas.Note the 'No Auto_Increment Set' checkbox, which is set by default. This removes any Auto_Increment={number} string in the result.
- Rename Table
This option generates a RENAME TABLE statement from the selected table name to the string in the 'New Name' textfield to the right of the radio buttons.
