This would actually be a very useful developer-experience improvement, especially during rapid iteration in development and testing environments.

Right now, clearing a table often means either:

• deleting rows manually
• writing a temporary SDK/script call
• dropping and recreating the table
• running direct database commands externally

For development workflows, that creates unnecessary friction for something that is conceptually a very common operation.

A dedicated “Truncate table” action in the Console would make a lot of sense, particularly if it:

• removes all rows efficiently
• resets auto-increment/sequence values
• preserves schema/indexes/permissions
• avoids requiring external scripts or SDK usage

Something like this under the Settings section would probably fit naturally:

Danger Zone

[ Truncate Table ]
Removes all rows and resets sequences.
Table structure, indexes, and permissions remain unchanged.

A few safety mechanisms would probably also be important:

• confirmation modal requiring table name input
• environment warnings for production projects
• optional “reset sequences” checkbox
• audit logging
• permission restrictions
• soft-disable in production environments

From an API/SDK perspective, a dedicated operation could also be cleaner than relying on deleteRows() with empty filters, because truncation is semantically different from row-by-row deletion and usually much faster at the database level.

For larger datasets especially, true truncation can provide:

• significantly faster execution
• lower transaction overhead
• reduced lock contention
• sequence reset support

This feels like one of those small features that ends up saving developers a surprising amount of time during testing and iterative schema development.

Related references:

• [PostgreSQL TRUNCATE Docs](https://www.postgresql.org/docs/current/sql-truncate.html?utm_source=chatgpt.com)
• [Appwrite TablesDB Docs](https://appwrite.io/docs/products/databases/tablesdb?utm_source=chatgpt.com)

Definitely seems like a reasonable and practical console enhancement.