Drop table

One or several Qlik Sense internal tables can be dropped from the data model, and thus from memory, at any time during script execution, by means of a drop table statement.

Syntax:  

drop table  tablename [, tablename2 ...]

drop tables [ tablename [, tablename2 ...]

 

The following items will be lost as a result of this:

• The actual table(s).
• All fields which are not part of remaining tables.
• Field values in remaining fields, which came exclusively from the dropped table(s).

Examples and results:

Example	Result
drop table Orders, Salesmen, T456a;	This line results in three tables being dropped from memory.
Tab1: SQL SELECT* from Trans; LOAD Customer, Sum( sales ) resident Tab1 group by Month; drop table Tab1;	As a result only the aggregates remain in the memory. Trans data is discarded.