Just a question : What is the difference between :

--------------

CREATE TABLE myTable
(
field1 INTEGER NOT NULL,
field2...
)

----------------

and

----------------

CREATE TABLE myTable
(
field1 INTEGER,
field2...
CONSTRAINT "field1nullcheck" CHECK (field1 IS NOT NULL),
)

----------------


TIA,

Heiko

Heiko,

The only difference I can think of is that column constraints are
checked before table constraints, so in the first case the check for
field1 not being null will occur before check constraints, primary key
constraints and foreign key constraints.

--
Fernando Dias
[Team Elevate]

Heiko,

<< Just a question : What is the difference between : >>

Not much - just what Fernando indicated.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks !!