There are two types of CONSTRAINT clauses: one for creating a constraint on a single field and one for creating a constraint on more than one field. Note The Microsoft Access database engine does not ...

Specifies whether the column can accept NULL values. Columns that do not allow NULL values can be added only if they have a default specified. If the new column allows NULL values and no default is ...