Delete Table Command

If you are a Business Administrator with table access, you can delete system tables. If you are a Business Administrator with person access, you can delete tables in any person’s workspace (likewise for groups and roles). Other users can modify only their own workspace tables.

You must be a business administrator with group or role access to delete a table owned by a group or role.

If a table is no longer required, you can delete it using the Delete Table command.

delete table NAME [user USER_NAME | system];

  • NAME is the name of the table to be deleted. If you are a business administrator with person access, you can include the User clause to indicate another user’s workspace object.
  • USER_NAME refers to a person, group, role, or association.
  • system refers to a table that is available for system-wide use, and not associated with the session context.

This command searches the list of defined tables. If the name is found, that table is deleted. If the name is not found, an error message is displayed.

For example, to delete the table named “Income Tax Table,” enter the following:

delete table "Income Tax Table";

After this command is processed, the table is deleted and you receive an MQL prompt for another command.