Skip to main content
Drop table

ON THIS PAGE

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 ...]

 

Information noteThe forms drop table and drop tables are both accepted.

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:  

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.

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com