# Drop field

One or several QlikView fields can be dropped from the data model, and thus from memory, at any time during script execution, by means of a drop field statement. The "distinct" property of a table is removed after a drop field statement.

Information noteBoth drop field and drop fields are allowed forms with no difference in effect. If no table is specified, the field will be dropped from all tables where it occurs.

Syntax:

Drop field fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]

Drop fields fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]

Examples:

`Drop 
 field A;` `Drop 
 fields A,B;` `Drop 
 field A from X;` `Drop 
 fields A,B from X,Y;`

## Learn more

* [Drop table](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/drop-table.htm)
* [Drop](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Drop.htm)
* [Field/Fields](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Field.htm)