The trash

Deleting a table or a field does not destroy it at once. It moves to the trash of its database, with its records or its values, and you can put it back for 30 days. On the date the trash shows, it is deleted for good.

Open the trash

1. Choose Data in the sidebar and pick the database's tab.
2. Choose the ⋮ beside New, then Trash.

The trash lists Tables and Fields apart. Each entry says when it was deleted, by whom and when it goes for good, for example Deleted 12 Oct, 10:27 by Ana Popescu · deleted for good on 11 Nov. A field also says which table it was part of. The trash shows what you yourself may delete.

Restore a table or a field

Choose Restore beside it. A table comes back with its records, its fields and who may open it. A field comes back into its table with every value it held.

If something else has taken the name in the meantime, Sterodata does not restore it and says so, for example A table named “Orders” is here now. Rename it, then restore this one.

Undo straight away

Right after you delete a table or a field, a message such as “Orders” moved to the trash stays for 12 seconds with Undo. Undo is the same as restoring it from the trash.

Deleted records

Deleted records have an Undo of their own for 12 seconds, on the message that says how many rows were deleted. They are not listed in the trash.

Once that message has gone, the app gives no way to bring deleted records back. Check what is ticked before you choose Delete selected.

What has no trash

• Tables and fields of a connected database. Deleting there cannot be undone.
• Dynamic tables and summaries, which are deleted for good.

A whole workspace has a trash of its own: see Users and your account.