Requires data in the column to be unique, multiple nulls are allowed. When used in conjunction with NOT NULL, it is effectively identical to a PRIMARY KEY.
Cannot be applied to UNIQUE constraint on a column of TIMESTAMP WITH TIME ZONE , CLOB or BLOB datatype.
May be applied to more than one column, however a table may only have one primary key.
Cannot be applied to TIMESTAMP WITH TIME ZONE, CLOB, or BLOB data types. Due to the size of LOB data types, indexing is not rational.
Requires that the referenced table’s column have a unique constraint only. A PRIMARY KEY constraint would satisfy this requirement, being the combination of UNIQUE and NOT NULL
Cannot be applied to TIMESTAMP WITH TIME ZONE , CLOB, or BLOB data types.
Requires a column to comply with a specific condition.
Cannot be applied to the Date datatype.
Prohibits a column from being null. Must be declared in line. All other constraints can be declared either inline or out of line.
A Web Developer by trade, future data scientist.
A motorcycle enthusiast at heart.
Most days I’d rather be in the woods anywhere.