Views

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

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

3. Fill in the required fields: “Schema name”, “Table name”, “View definition”. Description of all fields in Entities.

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

1. Go to [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 [Edit] to switch to edit mode.

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

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

In SQL, only a table can have a primary key. In “Abris”, a virtual primary key can be created for the view.

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

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

3. Set the flag in the field “Is primary key”. Description of the field in Properties.

4. Click the button [Save] to save changes or click [Cancel] to exit the edit mode without saving.

The primary key can only be set for an already created view.