> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/welcome-to-the-mysql-tutorial/sql-create-index-statement.md).

# SQL CREATE INDEX Statement

#### CREATE INDEX Syntax

Creates an index on a table. Duplicate values are allowed:

```
CREATE INDEX index_name
ON table_name (column1, column2, ...);
```

#### CREATE UNIQUE INDEX Syntax

Creates a unique index on a table. Duplicate values are not allowed:

```
CREATE UNIQUE INDEX index_name
ON table_name (column1, column2, ...);
```

### CREATE INDEX Example

```
CREATE INDEX idx_lastname
ON Persons (LastName);
```

```
CREATE INDEX idx_pname
ON Persons (LastName, FirstName);
```

### DROP INDEX Statement

```
ALTER TABLE table_name
DROP INDEX index_name;
```