CREATE UNIQUE INDEX
SQL> SQL> CREATE TABLE myTable ( 2 myTableID INT PRIMARY KEY NOT NULL, 3 Name VARCHAR(50), 4 PhoneNo VARCHAR(15) DEFAULT 'Unknown Phone'); Table created. SQL> SQL> CREATE UNIQUE INDEX NameIndex ON myTable (Name); Index created. SQL> SQL> drop table myTable; Table dropped.