Add constraint Fields

BIZ BIZ Feature Requests
1

Add constraint to a field:

TAccess
...
ValidAccessId INTEGER DEFAULT 0 NOT NULL
CONSTRAINT ValidAccess CHECK (ValidAccessId=0 or ValidAccessId=1 or ValidAccessId=2),
...
end;

Every SQL Engine support CONSTRAINT fields

2

This will require a specific syntax for each database, since Aurelius is database agnostic. If we implement this, you will need to inform the check constraint for each SQL dialect. Finally, this would only be used when creating the column, since changing the check constraint is also not guaranteed to work, it will not be applied when changing existing columns.