SQL>
SQL> create table department (
2 Dept_no NUMBER(3),
3 Dept_name VARCHAR2(15),
4 Location VARCHAR2(25),
5 CONSTRAINT Dept_name_ukey UNIQUE (Dept_Name,Location));
Table created.
SQL>
SQL>
SQL> drop table department;
Table dropped.
SQL>
SQL> --