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




Reply With Quote