SQL Table Statistics
The Tables Info activity is a database-wide catalog of every table in the current database with its live storage footprint — row count, data size, index size, total size, and where the driver exposes them, the storage engine, current auto-increment value, and create/update timestamps. It's the go-to view for "what's in this database and how big is it" before drilling into a specific table.
SQL support is in active development — the activity carries a BETA badge in its breadcrumb. Behavior around less-common dialects and very large databases may change.
Open Tables Info from a database in the SQL connection sidebar. There is one activity per (connection, database) pair; the breadcrumb at the top identifies which server and database you're looking at.
Every table in the database appears as one row. Columns are sortable by clicking their header; some columns are only shown when the driver reports the underlying value (typically MySQL/MariaDB for engine and auto-increment).
| Column | What it shows |
|---|---|
| Table | Table name. Clickable — opens the row's data in the SQL Table activity. |
| Rows | Row count as reported by the driver's catalog (usually the estimate, not an exact COUNT(*)). |
| Data Size | Row-storage bytes, human-formatted. |
| Index Size | Sum of all index bytes. |
| Total Size | Data + indexes. |
| Engine | Storage engine (MySQL/MariaDB — e.g. InnoDB). |
| Auto Inc | Current auto-increment value (MySQL/MariaDB). |
| Created / Updated | Timestamps from the driver's catalog where available. |
| Actions | Row-hover buttons: pencil to alter/manage schema, trash to drop. |
SELECT COUNT(*) in the SQL Editor if you need an exact number.COUNT(*) or investigate size details beyond the summary.Download and start managing your MongoDB databases with ease.
Download Free Trial