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)