Working with data
Databases, schemas and objects
Create databases, schemas, tables and other objects; see their SQL, rename, duplicate or empty them, and run maintenance.
Create
Right-click a connection → “New database…”, or a database → “New schema…”. In MongoDB, a database is created together with its first collection.
Right-click a database, a schema or a tree folder → “New …” creates a table, view, materialized view, function, procedure, trigger, sequence, event, index, type, synonym or package, depending on what the engine has. Tables are created in the designer; the rest opens an editor with a template to fill in.
See its details
When you pick an object in the tree, the right panel shows its columns, its primary key and the SQL that creates it. Right-click → “View SQL” opens it in full.
In the objects panel, the “Relations” column says which tables each one points to and which use it.
Export its SQL
Right-click → “Export SQL…” saves a script that creates the chosen objects, in an order that can run: first what others need, then the data and last indexes and foreign keys. With “Include the tables' data” it adds an INSERT per row.
Table actions
| Action | What it does |
|---|---|
| Duplicate here → With its data / Structure only | Creates a copy in the same schema under another name. |
| Rename… | Renames it. Anything using the old name stops finding it. |
| Empty the table (DELETE)… | Deletes all its rows. The auto number goes on where it was. |
| Truncate the table (TRUNCATE)… | The same, faster, and the auto number starts over. Fails if another table references it with a foreign key. |
| Drop… | Deletes the table and its data from the server. |
Everything that deletes data asks for confirmation and says which connection it happens on.
Maintenance
“Maintenance” lists your engine's operations:
- MySQL and MariaDB: Update statistics (ANALYZE), Optimize and compact (OPTIMIZE), Check (CHECK) and Repair (REPAIR).
- PostgreSQL: Update statistics (ANALYZE), Reclaim space (VACUUM), Reclaim and compact (VACUUM FULL) and Rebuild indexes (REINDEX).
- SQL Server: Update statistics, Rebuild indexes (REBUILD) and Check (CHECK).
- Oracle: Update statistics.
The result and the server's messages show in the task bar at the bottom.
Delete several
Pick several objects with Ctrl or Shift + click in the tree or the objects panel and press Del. Qrulla shows the full list before deleting.
Something missing or unclear? Write to support@qrulla.com.