# index-Name

An index-Name represents an index. Indexes live in schemas, so you can qualify their names with schema-Names. Indexes on system tables are in the SYS schema.

#### Syntax

    [ schemaName . ] SQL92Identifier

#### Example

    DROP INDEX APP.ORIGINDEX;
    -- OrigIndex is an index-Name without a schema-Name
    CREATE INDEX ORIGINDEX ON FLIGHTS (ORIG_AIRPORT)

Parent topic: SQL identifiers
Related concepts
Rules for SQL92 identifiers
SQL92Identifier
Related reference
column-Name
correlation-Name
new-table-Name
schemaName
Simple-column-Name
synonym-Name
table-Name
view-Name
constraint-Name
cursor-Name
TriggerName
AuthorizationIdentifier