Example:

create table TBL_PERSONWORK (
PERSONID NUMBER(9) not null,
LIMIT NUMBER(3),
PEREVERY NUMBER(3),
DAP NUMBER(5),
HAZARD NUMBER(1),
constraint PK_PERSONWORK primary key (PERSONID)
using index
tablespace INDX
);

So the 'not null' on PERSONID adds an extra not null constraint when this is already covered by the PK constraint?

Slimdave - Thanks for your help.

Cheers