Oracle Database Discussions

Hello,

let me know whats meaning by this....
Here, it creates a primary key and disable it... So whats the purpose of doing this...
(defines and disables an integrity constraint)
Constraint is DISABLED. is it in VALIDATE state / NO-VALIDATE state)


CREATE TABLE emp (
empno NUMBER(5) PRIMARY KEY DISABLE, . . . ;

ALTER TABLE emp
ADD PRIMARY KEY (empno) DISABLE;

Thanks

Edited by: Zerandib on Nov 12, 2008 6:47 AM