4.2.8 Reload Tables

As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine.

Reload tables with default routine option values:

mysql> CALL sys.HEATWAVE_RELOAD(NULL);

mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT());

Reload all user-loaded and automatically-loaded tables:

mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false));

Reload all user-loaded tables with the output option set to silent:

mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("output","silent"));

Reload all user-loaded and automatically-loaded tables with the output option set to silent:
```
mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false,"output","silent"));
```

To learn more about user-loaded and automatically-loaded tables, see Automatic Loading and Unloading of DB System Tables and Partitions.