Removing a Table

Available to: Developers, Admins Minimum plan: Free

Each row on the Table Definitions index page includes a Remove action (trash icon). Removing a table permanently deletes the table definition from the branch while preserving the underlying data.

How to Remove a Table

Prerequisites

  • Developer permission on the table's domain and branch
  • The table must not be referenced by foreign keys in other active tables

Steps

  1. Navigate to Development > Table Definitions
  2. Find the table you want to remove
  3. Click the trash icon on the table's row
  4. In the confirmation dialog, type the table name to confirm
  5. Click Continue

What Happens During Removal

TitanRDM performs these actions in a single transaction:

  1. The physical database table is renamed with a _t_rem suffix (e.g., dev.currency_codes becomes dev.currency_codes_t_rem)
  2. The deployed table definition and its deployed column definitions are destroyed
  3. The table definition itself (and its column definitions, import mappings) are hard-deleted from the metadata
  4. The table disappears from the sidebar and is no longer accessible for data entry

Important: The underlying data is preserved in the renamed physical table. It is not dropped.

Blocked Removals

You cannot remove a table if other active tables reference it via foreign key columns. The confirmation dialog will display the blocking tables instead of the confirmation input. You must remove or update those referencing tables first, then retry.

Automatic Cleanup of Removed Tables

Removed tables are not kept indefinitely. A background job runs daily and permanently drops any _t_rem physical tables that have been in the removed state for 7 or more days.

When the cleanup job runs for a removed table:

  1. The _t_rem physical table is dropped from the tenant database
  2. Any remaining deployed table definition record is hard-deleted
  3. The table definition record is hard-deleted

Warning: Once the cleanup job has run, the data in the removed table is permanently gone and cannot be recovered through the UI.

Related Pages