At 01:12 AM 9/10/2006 +0330, Behrang Saeedzadeh wrote:
>Hi,
>
>Shouldn't this create statement trigger an error?
>
> create table bar (col1 int not null default null);
No.
>Shouldn't I be forbidden to insert null values into a non null column?
Yes.
Use "not null default null" when you want to force apps/people etc to
explicitly specify values when inserting.
Link.