Powerdesiger Modifying the Engin of a Table or database of Mysql databases

1. Working PowerDesigner

2. Select File-new

3. Create a new table from the tool icon

   In the Properties window of the table

   Select Physical Options tab

4. Select Type= (ISAM) from the list on the left

   Click >> to select it to the right-hand side of the list select Type= (ISAM) below the type= selection list will appear

   You can choose the corresponding InnoDB, ISAM, etc.

5. Click Preview to view the appropriate SQL statement when you are finished selecting

6. If the database is modified, you can choose Database->default Physical options

   Same as selection at table above

   the more you can do is choose Apply to ... Button and tick the relevant table and click OK to confirm

7. Of course, the above action is only for the type actually physical options and other relevant option

   It should be helpful to us to further customize SQL

Powerdesiger Modifying the Engin of a Table or database of Mysql databases