Columns

Adding a column

  1. Go to alt [Menu] > [Configuration] > [Properties] (or [Configuration] > [Entities] > [Selected table] > [Properties]).

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

  3. Fill in the required fields: “Entity”, “Column name”, “Data type in database”. Description of all fields in Properties.

  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 instructional video for details:

Deleting a column

  1. Go to alt [Menu] > [Configuration] > [Properties] (or [Configuration] > [Entities] > [Selected table] > [Properties]).

  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 column while it is referenced by objects (foreign keys, views, etc.).