# 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 ...}

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

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/drop-table.htm)

#### Examples and results:

| Example | Result |
| --- | --- |
| `drop table<br>Orders, Salesmen, T456a;` | This line results in three tables being dropped from memory. |
| `Tab1:`<br>`Load * Inline [`<br>`Customer, Items, UnitPrice`<br>`Bob, 5, 1.50`<br>`];`<br>` `<br>`Tab2:`<br>`LOAD Customer, Sum( Items * UnitPrice ) as Sales`<br>`resident Tab1`<br>`group by Customer;`<br>` `<br>`drop table Tab1;` | Once the table Tab2 is created, the table Tab1 is dropped. |

## Learn more

* [Rename table](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/rename-table.htm)
* [Drop field](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/drop-field.htm)
* [Drop](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Drop.htm)
* [Table/Tables](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Table.htm)