NexusDB V3 Manual

The Database Context Menu

On setting the focus to a particular alias in the currently selected Server, a further context menu to manipulate that alias and tables therein is available for use.  The items in this popup menu are shown in the following screen shot.  This menu set allows you to manipulate the selected database alias and to work on the tables within that alias.

New Table (Ins)

Open the Create Table Dialog dialog.  See the according chapter for details about creating a new table.

SQL (F4)

Opens a SQL window for querying on the active database. See more info on the query window in the chapter The SQL Window.

New Database Alias

Create a new alias on the server this database belongs to.  This is the same dialog linked to the similar menu option for the popup menu associated with servers.

Delete Database Alias

Remove an alias. The command only removes the alias from the server's list of aliases, no tables or directories are physically deleted.

Rename Database Alias

Give the alias another name.

Start Transaction

Starts a transaction on the database. The database node in the tree will get a circled "T" marker to indicate that a transaction is in progress: All normal table- and SQL operations will now operate in the context of this transaction. Caution: keep in mind that using transactions on a database where other people are working, will lock others out from doing their work. Use with extreme caution in production environments!

Commit Transaction

Commits all edits done since the Start transaction command.

Rollback Transaction

Rolls back all edits done since the Start transaction command

Live Backup

Run a backup from one server/database to another, even while the database is in use.

Restore

Copy back tables that was previously backed up. This command also works if you just want to copy tables from one server/database to another.

Referential Integrity

Opens a dialog where RI can be defined. The view shows RI links between all tables in the database.

Design Report

Opens the design report window.

Refresh

Updates all nodes below it (tables, views, etc).

CSV Import

Import CSV data into a new NexusDB table. Supports most variants of CSV and date formats. See section The CSV Import Wizard for detailed info on the import wizard.