Enum CheckOperatorType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies the operators that can be used within check constraint expressions.

public enum CheckOperatorType

Fields

Equals = 1

Equality comparison operator (=).

NotEquals = 2

Inequality comparison operator (!= or <>).

LessThan = 3

Less than comparison operator (<).

GreaterThan = 4

Greater than comparison operator (>).

LessThanOrEqualTo = 5

Less than or equal to comparison operator (<=).

GreaterThanOrEqualTo = 6

Greater than or equal to comparison operator (>=).

Like = 7

Pattern matching operator for string comparisons (LIKE).

Between = 8

Range check operator to test if a value falls within a range (BETWEEN).

In = 9

Set membership operator to test if a value exists in a list (IN).

NotIn = 10

Negated set membership operator (NOT IN).

IsNull = 11

Null check operator to test if a value is NULL (IS NULL).

IsNotNull = 12

Non-null check operator to test if a value is not NULL (IS NOT NULL).

Add = 13

Addition arithmetic operator (+).

Subtract = 14

Subtraction arithmetic operator (-).

Multiply = 15

Multiplication arithmetic operator (*).

Divide = 16

Division arithmetic operator (/).

OpenBracket = 17

Opening parenthesis for grouping expressions.

CloseBracket = 18

Closing parenthesis for grouping expressions.

And = 19

Logical AND operator for combining conditions.

Or = 20

Logical OR operator for combining conditions.

ListSeparator = 21

Comma separator for list items in IN clauses.

Not = 22

Logical NOT operator for negating conditions.

Remarks

Check constraint operators include comparison operators, logical operators, arithmetic operators, and structural elements like brackets. These operators are combined with values and column references to create validation rules.