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

 

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