# Unique Keys And Indexes

__*UNIQUE KEY*__

+ Unique keys have the following characteristics:
  + Uniquely identifies a single row in a table
  + accept `NULL` 
  + Allows multiple unique keys per table
```12
tidb> CREATE TABLE test.dropme (
   ->   id BIGINT AUTO_RANDOM,
   ->   name CHAR(35) NOT NULL,
   ->   PRIMARY KEY (id),
   ->   ~!@UNIQUE KEY@!~ (name)
   ->   );
tidb> SELECT key_name, column_name, index_id FROM information_schema.tidb_indexes 
   -> WHERE table_schema='test' AND table_name='dropme';
+----------+-------------+----------+
| key_name | column_name | index_id |
+----------+-------------+----------+
| PRIMARY  | id          |        0 |
| ~!@name@!~     | name        |        1 |
+----------+-------------+----------+
```
------------------------------------------------------------
[no notes]