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

 

Note: The 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).