Databases & tables
Databases & tables
The sidebar shows a tree of every database your account can see. Tables load when you expand a database, and the filter box at the top (press /) narrows the tree as you type.
#Databases
The databases page lists each database with its size, table count and default collation. From here you can:
- Create a database with a character set and collation.
- Rename a database.
- Drop a database. You must type its name and re-enter your MySQL password.
#Browsing a table
Table pages have tabs: Browse · Structure · Indexes · Foreign keys · SQL · Operations.
The browser is built for big tables:
- Keyset paging. Where the table has a usable key, DBNova pages by key instead of
OFFSET, so any page of a 10M-row table loads in 3–8 ms. - A virtualized grid. Only visible rows and columns are drawn, so a 120-column table scrolls at 60 fps.
- NULL is not empty.
NULLshows as a muted badge, an empty string as an empty cell, and BLOBs as[BLOB 12 KB]. - Sticky header and first column, column resize, server-side sort and a filter row per column.
#Editing rows
On tables with a primary or unique key you can:
- double-click a cell to edit it (Enter saves, Esc cancels);
- insert new rows;
- select rows and delete them in bulk (with confirmation).
Saves are optimistic and roll back with the MySQL error message if the server refuses them.
#Changing the schema
Create and alter tables, columns, indexes and foreign keys from the Structure tab. Before anything runs, DBNova shows the exact SQL it will execute in a read-only editor. Online ALTERs (ALGORITHM=INSTANT or INPLACE) are used where your MySQL version supports them.