Re^2: Access won´t allow ENUM, DEFAULT etc in CREATE

Ah, thanks. But it seems to me that NOT NULL is a common SQL tag.

Comment on Re^2: Access won´t allow ENUM, DEFAULT etc in CREATE

Replies are listed 'Best First'.
Re^3: Access won´t allow ENUM, DEFAULT etc in CREATE by gaal (Parson) on Mar 15, 2005 at 08:10 UTC
`NOT NULL` is not the same as `DEFAULT`. `DEFAULT` means that if a value is not supplied in insertion, the database gives one by, well, default. `NOT NULL` means this field must not be omitted in the `INSERT` (unless there's a default!), nor can it be set to `NULL` (which is not the same thing as an empty string in SQL) later with an `UPDATE`.	[reply] [d/l] [select]