4D v13.4

DROP INDEX

4D SQL Reference
- SQL Commands
- - SQL Commands
  - SELECT
  - INSERT
  - UPDATE
  - DELETE
  - CREATE DATABASE
  - USE DATABASE
  - ALTER DATABASE
  - CREATE TABLE
  - ALTER TABLE
  - DROP TABLE
  - CREATE INDEX
  - DROP INDEX
  - LOCK TABLE
  - UNLOCK TABLE
  - EXECUTE IMMEDIATE
  - CREATE SCHEMA
  - ALTER SCHEMA
  - DROP SCHEMA
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

4D v13.4

DROP INDEX



	DROP INDEX sql_name

Description

The DROP INDEX command is used to remove an existing index named sql_name from a database. It cannot be used on indexes created for PRIMARY KEY or UNIQUE constraints.

Example

Here is a simple example for removing an index:

DROP INDEX ID_INDEX

PROPERTIES

Product: 4D
Theme: SQL Commands

INDEX

Alphabetical list of commands