Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  Unloading Tables

Chapter 5 Unloading Tables

Unloading a table from HeatWave may be necessary to replace an existing table, to reload a table after a change propagation failure has caused data become stale, to free up memory, or simply to remove a table that is no longer used.

To unload a table from HeatWave, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement:

mysql> ALTER TABLE orders SECONDARY_UNLOAD;

Data is removed from HeatWave only. The table contents on the MySQL DB System are not affected.