NexusDB V3 Manual

Table Structure Window

Use the Table Restructure window to view and edit the table dictionary.  If you select the View Fields or View Indices options, this screen is in read-only mode.  The table can only be restructured by the Redefine menu option.  The window looks like this when opening:

The NexusDB Data Dictionary stores all meta information about tables. For each information EM presents the user with a separate category. If you're using the EM shipped with NexusDB the categories are available as displayed in the treeview in the image above.

Let's take a closer look at each of them. The first is the Main Table Name edit. This is the root name of the table and also the name used for the table on disk (+ the extension).

While in NexusDB V1 Tablename could be any valid windows filename and it was limited only by the OS in size and characters, NexusDB V2 restricts the filename to be in sync with the SQL:2003 standard's Regular Identifier definition. This is necessary to ensure full compatibility with this standard.