columnLevelConstraint [ CONSTRAINT constraintName ] { NOT NULL | CHECK ( searchCondition ) | PRIMARY KEY | UNIQUE | REFERENCES clause } [ constraintCharacteristics ]

A searchCondition is any boolean expression that meets the requirements specified in .

If a constraintName is not specified, generates a unique constraint name.