DELETE command

Used to delete ACL project items, fields from table layouts, variables, table history entries, relations between tables, and physical files in Windows folders. Also used to remove columns from views.




To delete an ACL project item

DELETE item_type item_name <OK>

To delete all record notes, and the auto-generated RecordNote field, from the open table


To delete a field from a table layout

DELETE field_name <OK>

To remove a column from a view

DELETE COLUMN view_name column_name <ALL> <OK>

To delete a variable or all variables

DELETE {variable_name|ALL} <OK>

To delete the history for the current ACL table

DELETE HISTORY retain_history_entries <OK>

To delete a relation between two tables

DELETE RELATION <child_table_name|relation_name> <OK>

To delete a file

DELETE file_name <OK>



Specify one of the following ACL project item types:

  • FOLDER – Deletes the specified project folder and all its contents.

  • FORMAT – Deletes the specified table layout, all its views, and its associated indexes and relations. Any other table layouts for the associated table are retained. The data file (.fil) is not deleted unless the Delete Data File with Table checkbox is selected in the Table tab in the Options dialog box (Tools > Options).

  • REPORT – Deletes the specified view.

  • SCRIPT or BATCH – Deletes the specified script.

  • WORKSPACE – Deletes the specified workspace.

  • INDEX – Deletes the specified index.

  • NOTES – Deletes all record notes from the open table, and the RecordNote field from the table layout.


Specifies the name of the ACL project item to delete.


Specify a field name in the current ACL table layout.


Specifies the name of the view to remove the column from.


Specifies the name of the column to remove.


Specifies that if the column occurs more than once in the view, all instances will be removed. If there is more than one instance of the column, and the ALL parameter is not specified, the leftmost instance of the column is removed.

variable_name | ALL

Specify the variable name to delete, or ALL to delete all variables. If you specify ALL, all system variables, and temporary and permanent user-defined variables, are deleted from the project.

HISTORY retain_history_entries

Specifies that all of the table history entries will be deleted except for the number of most recent entries specified by the retain_history_entries parameter.

RELATION <child_table_name | relation_name>

Deletes any relation that has no dependent relations and no related fields referenced in either the active view or in an active computed field. The child_table_name or relation_name qualifier specifies which relation to delete. Use the relation_name qualifier if the relation was specifically named when it was created. Otherwise, use the child_table_name, which is the default relation name when a relation is created. If you do not add this qualifier, ACL deletes the last relation defined.


Specify the name of a physical file. You can specify an absolute or relative path to a file you want to delete. If the path has spaces, enclose it in double quotation marks.


Optional. Specifies that the confirmation dialog box is suppressed.


You can delete a field from a table layout even if the field is included in the current view. You cannot delete a field or variable referenced by a computed field unless you first delete the computed field.

You cannot delete a view if it is currently active.


In the following example, the “Date” field is deleted from the table layout associated with the “Ar” table.


In the following example, two columns are removed from the “AR_Report” view associated with the “Ar” table. The OK parameter is used with both DELETE commands so that no confirmation prompt is displayed when the script runs.

DELETE COLUMN AR_Report Invoice_Date OK

(C) 2015 ACL Services Ltd. All Rights Reserved.