Convert Tables
Go Up to Available object actions by DBMS
This action lets you build and submit an ALTER TABLE statement, specifying an ENGINE= option, specifying any available storage engine.
- Note: For information on how to quickly convert a table to use the INNODB storage engine, see Rebuild Table.
Platform Availability
To Change the Storage Engine for a Table
- Initiate a Convert Tables action against one or more tables. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in this wizard:
| Step | Settings and tasks | |
|---|---|---|
|
Action Options |
Use the Convert To dropdown to select an available storage engine. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For more information, see Preview. | |
- 3. Click Execute. For information on the scheduling option, see Scheduling.