ORACLE 经常使用的命令工具-第五章:约束

C%zR7g,g4u0　　1.define constraints as immediate or deferred

　　sql> alter session set constraint[s] = immediate/deferred/default;

　　set constraint[s] constraint_name/all immediate/deferred;

pHJ2S3fFe w1Z S(n u0　　2. sql> drop table table_name cascade constraints51Testing软件测试网K4C/F5D)Y9{w z

　　sql> drop tablespace tablespace_name including contents cascade constraints

z.A)j_:{q0NFbn$f?,a0　　3. define constraints while create a table

,KSm1~#bOKc0　　sql> create table xay(id number(7) constraint xay_id primary key deferrable

(cCi;{~Tr1z0　　sql> using index storage(initial 100k next 100k) tablespace indx);51Testing软件测试网6bg9}m3NLV v

|qwJr0　　primary key/unique/references table(column)/check51Testing软件测试网1`(C _%kf gU5i

　　4.enable constraints

)o Xz
D$Z*H&dX-\0　　sql> alter table xay enable novalidate constraint xay_id;51Testing软件测试网5G
i(_8CfU~

DMZD%{9B dWN o0　　5.enable constraints

T_,[R^oM0　　sql> alter table xay enable validate constraint xay_id;51Testing软件测试网cEWrWkD4a1O