No Strict Key Checking on CREATE TABLE

Checking this box, if no primary key is specified, causes a primary key to be created using as many columns as can be fit into the 120-character maximum key length restriction. If this option is not selected, the user must explicitly specify a primary key when creating a table or an error will occur.

For example:

CREATE TABLE foo (id integer primary key, name char(20), address char(40))