By default, SAP HANA database will automatically manage the load and unload of tables. However, we can also, manually execute the loading or unloading of the table for certain cases. There are 2 ways of executing this task, by command line or using HANA Studio.
Method 1: Load / Unload using Command Line
Open the SQL command (throught the HANA studio) and execute the following command.
LOAD [Table-Name] UNLOAD [Table-Name]
Method 2: Load / Unload using HANA Studio
Launch the HANA Studio. From the system view, navigate to Catalog > SAPABAP1 (Your Schema DB) > Tables. Filter to list out your target table. In this example, we are going to use table DEVACCESS_BACKUP.
Right click on the table and select Load into Memory (yeah, it is mean to load) or Unload from Memory (if you want unload it).
Below screenshot shows the example when we trying to load the DEVACCESS_BACKUP table into the memory. Click on OK. Depending on the size of the table, huge size will take some time to complete. Our loading was fast because it’s a very small table.
Once loaded, you can double click on the table and jump to Runtime Information tab. From here, you will see the Loaded status say FULL. In the Columns tab, the Loaded status will state as TRUE.
Now, we are going for Unload activity. Click OK if below message prompted. The situation will be the same, huge size of table will take a longer time to complete.
As result, you will see the Loaded state as NO (as in Parts tab) and under Columns, it will state as FALSE.
Note
You can also load just the column table column by executing below command line. You can add one or more column by using the comma.
LOAD [TABLE-NAME] [COLUMN-1, COLUMN-2, ...]
