Delete a custom table
If you no longer need a custom table, you can delete it after you delete all the records in the table.
Before you begin
Role required: admin
Procedure
Navigate to All > System Definition > Tables.
Open the table to delete.
Select Delete All Records.
Deleting all records before deleting the table ensures that the business logic is properly executed (for example, reference cascade rules or other delete business rules). If you do not delete all records from the table first, then you must manually fix any other records or tables that the table deletion impacts. Cascade deletions are also taken care of in this step.
Select Delete.
The Delete button is only available for custom tables beginning with u_ (global) or x_ (scoped).
In the confirmation dialog box, enter
deleteand click OK.The table and all items that reference the table are deleted, including:
- Choice list items
- Forms, form sections, lists, and related lists
- Reports and Performance Analytics widgets
- Reference fields that reference the table
- Access controls
Parent Topic:Deleting custom tables
Related topics