Mega Code Archive

 

Categories / Oracle PLSQL / Constraints

 

Referential Integrity Constraints

SQL> SQL> create table department (   2      Dept_no  NUMBER(3) primary key,   3      Dept_name   VARCHAR2(15),   4      Location     VARCHAR2(25),   5      CONSTRAINT Dept_name_ukey UNIQUE (Dept_Name,Location)); Table created. SQL> SQL> SQL> create table employee (   2  Employee_id    number (7),   3  Last_name      varchar2(30),   4  First_name     varchar2(30),   5  Job            varchar2(15),   6  Department_id  number (3) NOT NULL   7                 Constraint dept_fkey REFERENCES department(dept_NO)); Table created. SQL> SQL> drop table employee cascade constraints; Table dropped. SQL> drop table department cascade constraints; Table dropped. SQL>