SQL for Reality > SQL Statements Supported by Reality > DROP INDEX Statement

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.2 Online Documentation (MoTW) Revision 3

DROP INDEX Statement (SQL) (m691508+dropindex.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

DROP INDEX Statement

Deletes an index from an SQL table.

Syntax

DROP INDEX index-name

Syntax Elements

index-name =
index-qualifier.index-identifier

index-qualifier
the base-table-name.

index-identifier
The name of the required index.

Restrictions

Only the SQL owner of the table can perform this statement. The owner must have SQL Catalog Maintenance privilege set in the Reality security profile

Comments

index-qualifier is required.

Example

DROP INDEX EMP.DEPTIDX

RealityV15.2Revision 3Comment on this topic