Drop table

One or several QlikView 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: Load * Inline [ Customer, Items, UnitPrice Bob, 5, 1.50 ];   Tab2: LOAD Customer, Sum( Items * UnitPrice ) as Sales resident Tab1 group by Customer;   drop table Tab1;	Once the table Tab2 is created, the table Tab1 is dropped.