Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.0Mb
PDF (A4) - 1.0Mb


MySQL HeatWave User Guide  /  HeatWave  /  Unloading Tables

2.5 Unloading Tables

Unloading a table from HeatWave may be necessary to replace an existing table, to reload a table, 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.