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.

Date = 2

A date literal value used in the constraint expression.

DateTime = 3

A datetime literal value used in the constraint expression.

Function = 4

A database function call within the constraint expression.

Interval = 5

An interval (duration) literal value used in the constraint expression.

Number = 6

A numeric literal value used in the constraint expression.

Operator = 7

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

Snippet = 8

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

String = 9

A string literal value used in the constraint expression.

Time = 10

A time-of-day literal value used in the constraint expression.

Timestamp = 11

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.