How do I delete a table?

[lzeke]

I created a couple of tables on Fuji (patch2) and it seems there is no way to delete them. In "Tables" there is no Delete on the selected rows and in Dictionary I can wipe out some of the field records (and the table record itself), but can't delete the sys columns of these tables. This should be easy to do - what am I missing?

[ProbirDas · Accepted solution]

Are you following the below steps?

1. Navigate to System Definition > Tables.

2. Open the table to delete.

3. [Recommended] Click 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 are impacted by the table deletion.

4. Click Delete.

5. In the confirmation dialog box, enter delete and 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 gauges
• Reference fields that reference the table
• Access controls

[lzeke]

Thanks, sorry, this was dumb on my part - I didn't look for a special "Delete" button on the Table form, and I should have..

[Pradeep Sharma]

Hi Laszlo,

Can you please close the thread if this is now resolved.

Please let me know if you have any questions.

[lzeke]

I would love to close it if you tell me how to do it.