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.