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>