DynamoOps
Schema and infrastructure

Truncating and deleting tables

Clear every item while keeping the table, or remove the table entirely. Both actions require typing the table name to confirm and cannot be undone.

Truncate Table

Truncate removes every item but preserves the table, its keys, indexes and settings. It is the fastest way to reset a development or test table. Click 🧹 in the table info bar.

Truncate stays disabled until the table name matches exactly.
  1. Type the table name

    The Truncate Table button stays disabled until the text matches exactly, including case.

  2. Confirm

    DynamoOps scans the table projecting only key attributes and deletes items in batches of 25 until the table is empty. The dialog shows “Deleting items…” and, when finished, the number removed.

  3. Review

    A toast reports “Table <name> truncated. Deleted N items.” and the current query re-runs.

Cost and duration
Truncate reads every key and writes a delete for every item, so it consumes both read and write capacity proportional to the table size, and runs as one uninterruptible request. On provisioned tables, throttled deletes are not retried; run truncate again to finish. For large production tables, deleting and recreating the table is cheaper.

Delete Table

Click 🗑 in the info bar. The Delete Table dialog warns that the table and all of its data will be permanently deleted. Type the table name to enable the red Delete Table button, then confirm. DynamoOps issues DeleteTable, closes the tab’s data view and refreshes the sidebar.

  • Tables with deletion protection enabled in AWS cannot be deleted here; the AWS error is shown inline.
  • Export the data first if there is any chance you will need it back.

Which one to use

Truncate when
  • You want to keep the schema, indexes, streams and IaC references intact.
  • The table is small or medium sized.
  • Applications keep pointing at the same table name.
Delete when
  • The table is large and the cost of per-item deletes is not justified.
  • You are retiring the table or recreating it with a different key schema.
  • You will recreate it from Terraform or CloudFormation anyway.

Related