4D v16

CREATE INDEX

Home

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
  - CREATE VIEW
  - DROP VIEW
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

Home

4D v16

4D - SQL Reference

SQL Commands

CREATE INDEX



	Command CREATE INDCREATE [UNIQUE] INDEX sql_name ON sql_name (column_reference, ... , column_reference)

Description

The CREATE INDEX command is used to create an index (sql_name) on one or more columns of an existing table (sql_name) designated by one or more column_reference type arguments. Indexes are transparent to users and serve to speed up queries.

You can also pass the optional UNIQUE keyword to create an index that does not allow duplicate values.

Example

Here is a simple example for creating an index:

CREATE INDEX ID_INDEX ON ACTOR_FANS (ID)

Siehe auch

column_reference
DROP INDEX

Vorige Seite

Nächste Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: SQL Commands

GESCHICHTE

ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)

Fehler melden