Enum CheckConstraintType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies the type of element that can appear in a check constraint definition.

public enum CheckConstraintType

Fields

Column = 1

A column reference within the check constraint expression.

Operator = 2

An operator used for comparison or logical operations in the constraint.

Number = 3

A numeric literal value used in the constraint expression.

String = 4

A string literal value used in the constraint expression.

Date = 5

A date literal value used in the constraint expression.

DateTime = 6

A datetime literal value used in the constraint expression.

Function = 7

A database function call within the constraint expression.

Snippet = 8

A raw SQL code snippet to be inserted into the constraint expression.

Timestamp = 9

A timestamp literal value used in the constraint expression.

Remarks

Check constraints are used to limit the values that can be placed in a column. They consist of various elements including column references, operators, literals, and functions combined to form validation expressions.