Referential Integrity Constraints : Create Foreign Key « Constraints « Oracle PL / SQL

1. Oracle PL / SQL
2. Constraints
3. Create Foreign Key

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>

   
  

Related examples in the same category