index statements.rst

INDEX STATEMENTS

POSTGRESQL

• CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] idx_name ON table_name [ USING method ] ( { col_name | ( expression ) } [ opclass ] [ ASC | DESC ]
• DROP INDEX [ IF EXISTS ] idx_name [, idx_name1, ...]

MYSQL

• CREATE [ UNIQUE | FULLTEXT | SPATIAL ] INDEX idx_name [ USING {BTREE | HASH} ] ON tbl_name (col_name [(length)] [ASC | DESC],...)
• DROP INDEX idx_name ON tbl_name;

ORACLE

• CREATE [ UNIQUE | BITMAP ] INDEX idx_name ON table_name (col_name [ ASC | DESC], ...) [ WHERE condition ]
• DROP INDEX idx_name [ FORCE ]

SQLITE

• CREATE [ UNIQUE ] INDEX [ IF NOT EXISTS ] idx_name ON table_name (col_name, ...) [WHERE expression]
• DROP INDEX [ IF EXISTS ] idx_name;