# Load and unload a table in SAP HANA using SQL query

SAP HANASAPSAP BasisjQuery

In SAP HANA, it is possible to manually load and unload individual tables and table columns.

• You can perform loading of table to precisely measure the total or “worst case” amount of memory used by a particular table.
• A table is unload from database to actively free up memory.

You can use following SQL queries to perform load/unload of table −

LOAD <table_name>
UNLOAD <table_name>

Published on 25-Apr-2018 20:12:38