drop index

Drop an index (key) from a table

Syntax

drop_index:
          DROP INDEX [[database_name.]table_name.]constraint_name

Description

Like create index, many SQL systems provide the non-standard drop index statement. The drop index statement provided in RDM SQL directly maps the above syntax into the standard alter table syntax shown below.

ALTERTABLE [database_name.]table_name DROP CONSTRAINT constraint_name

See Also

CREATE INDEX

ALTER TABLE