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

ENUM is a MySQL extension, not standard SQL. (Some other databases might have it too.) Access doesn't appear to support it.

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

Replies are listed 'Best First'.
Re^2: Access won´t allow ENUM, DEFAULT etc in CREATE by Lytse Flap (Initiate) on Mar 14, 2005 at 22:40 UTC
Ah, thanks. But it seems to me that NOT NULL is a common SQL tag.	[reply]
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]