NexusDB V3 Manual

The Table Context Menu

Drilling down even further in our focus, we can now concentrate on individual tables within an alias on a particular Server.  Setting the focus to a particular table in the currently active alias (in the selected Server), takes us to a further context menu to manipulate that table.  The items in this menu are shown in the picture below.

Browse Table

Open the Table browser window. See section The Table Browser Window for details about this window.

SQL (F4)

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

New Table (Ins)

Open the Create table window. See section Managing and viewing table structures for details about this window.

Delete Table (Del)

Deletes table permanently from disk. You need exclusive access to the table to the table for performing this task.

Rename Table

Changes the name of a table. You need exclusive access to the table to the table for performing this task.

Clone Table Structure

Creates a new table, with the exact same structure as the selected one. On selecting this menu you will be asked for the new name; enter the name for the new table and press OK.

View Dictionary

Open the Create/Restructure window in read-only mode, with the Fields tab active. See section Managing and viewing table structures for details about this window.

Restructure

Opens the Create/Restructure window with the current contents of the table. See section Managing and viewing table structures for details about this window.

Reindex

Choose an index in the dialog that you want to reindex,

and press OK. If you want to reindex all Indices at once it's better to use the Pack Table command. You need exclusive access to the table to perform this task.

Pack Table

Compact and reindex all Indices. This is achieved by creating a clone of the current table and batch copying all records. Although other databases need to regularly perform a pack table, NexusDB is a maintenance free database. You usually don't need to pack a table, as NexusDB reuses space of deleted records. If for some reason the line got pulled on a server and a table doesn't seem to be right, your first action should be to try to pack the table, as in most cases this will fix the problem. Exclusive access to the table is needed to perform this task.

If that does not help please take a look at the Recover Records command below.

Enter Password

Allows you to give the table a password. This will encrypt the tables on disk with strong encryption using the Blowfish algorithm, using the password as key.

Note carefully: the encryption is strong, there is no backdoor to open the tables if you lose the password!

Change Password

Changes the password on a table that already have a password set.

Set AutoInc

Allows you to change the last used autoinc value for a table.

The next insert operation will generate the value (newvalue+1) in the autoinc field.

Empty

Delete all the records in the table. This command is not reversible and you need exclusive access to the table.

Recover Records

If you have a table whose internal structure has been damaged, this function will attempt to extract all recoverable data into a new "tablename_recovered" table. Records that were not fully recoverable are copied into a "tablename_failed" table. Again, you need exclusive access to the table.

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.