Create Table or View
Click the plus button in the bottom-left of the sidebar and choose New Table or New View. New Table opens the visual structure editor (see Table Structure). New View opens a SQL editor tab with a CREATE VIEW template for your database type. The button is disabled while safe mode blocks writes.Drop and Truncate
Right-click a table and choose Delete to drop it, or Truncate to remove all rows while keeping the structure. Hold Cmd and click to select multiple tables; the same options apply to all of them. A confirmation dialog shows two checkboxes:
Click Drop or Truncate to execute, or Cancel.
Drop table confirmation with options
Maintenance
Right-click a table > Maintenance and pick an operation. A sheet shows the operation’s options and a SQL preview before executing.
PostgreSQL VACUUM has FULL (rewrites the table, blocks access), ANALYZE (updates statistics), and VERBOSE (prints progress) toggles. MySQL CHECK TABLE offers QUICK, FAST, MEDIUM, EXTENDED, and CHANGED modes.
The Maintenance submenu is hidden in read-only safe mode and on databases with no maintenance operations.
Views
Views appear in the sidebar with an eye icon in your accent color. Materialized views and foreign tables get their own icons. All three are read-only kinds: their context menus hide Truncate and Import, and the drop item is labeled Drop View, Drop Materialized View, or Drop Foreign Table.- Create: right-click in the sidebar > Create New View… (or File > New View…). A SQL editor opens with a CREATE VIEW template; edit the name and SELECT, then execute.
- Edit: right-click a view > Edit View Definition. The current definition opens in a SQL editor tab; modify and execute to update.
- Drop: right-click a view > Drop View. Only the definition is removed; underlying table data stays intact.
Database Operations
Switch Databases
Click the database name in the toolbar or pressCmd+K. Type to filter, move with the arrow keys, then press Return or double-click to switch. Cmd+R refreshes the list. The switcher adapts to the engine’s vocabulary: Schema on Oracle, Keyspace on Cassandra, Dataset on BigQuery, Namespace on SurrealDB. SQLite is file-based, so the switcher points you to the Welcome window to open a different file.
Database switcher with search
Create Database
Click New Database… at the bottom of the switcher. The form fields come from the driver: MySQL/MariaDB ask for a name, character set, and collation; PostgreSQL, ClickHouse, MongoDB, and others show their own fields. The button only appears on engines that support creating databases.Drop Database
Right-click a database in the switcher or in the sidebar tree and choose Drop Database…. The item is hidden for system databases and for the database you are currently connected to; switch to another one first. A confirmation dialog shows the database name in its title with a red Drop Database button.Work on Several Databases at Once
Select more than one database in the sidebar tree or in the switcher: Shift-click for a range, Cmd-click to add or remove one. The right-click menu then acts on the whole selection and says how many it covers, for example Drop 3 Databases….
The menu follows the row you right-click: if it is part of the selection, the action covers the selection; if it is not, the action covers just that row. Use as Active Database stays single-target and is disabled while more than one row is selected.
Databases the server will not let you drop are left out of the Drop item: system databases and the one you are connected to. If a drop fails partway, TablePro finishes the rest and then reports which ones failed and why.
Drop Schema
On engines that group tables by schema, the same menu appears on a schema row. PostgreSQL, SQL Server and SurrealDB support it. PostgreSQL drops the schema withCASCADE, so objects that depend on it go too. SQL Server has no cascade, so it refuses to drop a schema that still holds objects; drop those first.