Deleting a table removes a table and all the data stored within the table. This operation cannot be rolled back on the customer side. If the table needs to be recovered, reach out to support as soon as possible for help.
If you delete a table and then create a table immediately with the same name, wait at least 2 minutes before adding data to the new table to avoid risking a data loss.
You can prevent the deletion of tables that contain critical data that your company requires to be maintained over time.
The strict implementation of the Table Delete Protection feature prevents any user from running DELETE queries, deleting a table outright, or replacing the data within a table in any capacity. You can enable this feature on a per table basis by submitting a support request. Contact support or your account representatives with a list of tables you’d like to protect.
- You cannot use Expiring Data From A Table for the table that is set with
Table Delete Protection.
Navigate to Workbench > Databases.
Select the database for which you want to delete tables.
Select the table you want to delete.
Select ... > Delete table.
- Confirm or cancel the deletion.
The table:delete removes a table and all the data stored within the table.
$ td table:delete test_db test_table