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.