Tables

Creating a table

  1. Go to alt [Menu] > [Configuration] > [Entities] (or [Configuration] > [Schemas] > [Selected scheme] > [Entities]).

  2. Click the button alt [Add…] in tabular form.

  3. Fill in the required fields: “Schema name”, “Table name”, “Create primary key”. Description of all fields in Entities.

  4. Click the button alt [Create] to add an entry or a button alt [Cancel] to exit the add mode without saving data.

    See the instruction video for details:

Deleting a table

  1. Go to alt [Menu] > [Configuration] > [Entities] (or [Configuration] > [Schemas] > [Selected scheme] > [Entities]).

  2. Click on the entry (row) in the table to go to the detailed form.

  3. In the detailed form, click alt [Edit] to switch to edit mode.

  4. Click the button alt [Delete] to delete an entry or click alt [Cancel] to exit the edit mode without deleting.

You cannot delete a table while it is referenced by objects (foreign keys, views, etc.).