SQL: Create an index

A short, tested SQL example for create an index. Copy it and adjust the names and paths for your project.

SQL

CREATE INDEX idx_orders_customer ON orders (customer_id);
CREATE UNIQUE INDEX idx_users_email ON users (email);
DROP INDEX idx_orders_customer;

Find it in Zest

Search for “sql create an index” in Zest and this example appears above the results, with other matches to choose from. Searches stay private.