# indexName

An indexName represents an index. To create an index, use the CREATE INDEX statement.

## Syntax

    [ schemaName . ] SQLIdentifier

You can qualify an index name with a schemaName. If a qualified index name is specified, the schema name cannot begin with SYS.

## Example

    DROP INDEX APP.ORIGINDEX;
    -- OrigIndex is an indexName without a schemaName
    CREATE INDEX ORIGINDEX ON FLIGHTS (ORIG_AIRPORT)

Parent topic: SQL identifiers