top of page
CerebroSQL

SET CONSTRAINTS

RDBMS Type: Oracle

SET { CONSTRAINT | CONSTRAINTS }
{ constraint [, constraint ]...
| ALL
}
{ IMMEDIATE | DEFERRED } ;

Example

SET CONSTRAINTS ALL IMMEDIATE;

SET CONSTRAINTS emp_job_nn, emp_salary_min ,
hr.jhist_dept_fk@remote DEFERRED;

bottom of page