Table Operations

Rename Table

To rename a tablename select the table in the Object Browser and select Table -> More Table Operations -> Rename Table from the popup menu or press F2).

Empty Table

To delete all rows select the table in the Object Browser, right click and select Table -> More Table Operations -> Truncate Table (or press Shift+Delete). This option is also available in 'Tools' menu.

Select the Table to be emptied in the explorer window. You get a warning message box. Click Yes to truncate all data in the Table (but the table is NOT dropped from the database).

You get a message if the truncation is not permissible (e.g. attempting to drop rows with foreign key values)

Drop Table

Select the table you want to drop in the Object Browser and select Table -> More Table Operations -> Drop Table from the popup menu (or press Delete).

Reorder Columns

To change the sequence of columns in a table, select the table in the Object Browser and select Table -> More Table Operations ->Reorder Column(s) (Ctrl+Alt+R) from the popup menu.Select any column and click Up or Down button to move the column up / down. Having re-sequenced the columns, click Re-Order to save the table with changed structure. The column data in the table gets re-arranged accordingly.

Change Table Type

To change the Table type (or "Engine' as the term is for the latest MySQL versions), you select the Table Type from the drop down list you would like to change the selected table to. SQLyog queries ('asks') the server about what types/engines are available and only displays the ones available (that may vary considerably depending on the server version, the platform where the server runs and how it was compiled and how it is configured).