Indexes

This guide explains how to define indexes on your tables, configure their properties, and generate optimized SQL for supported database dialects.

To create a table index in StackRender, follow these steps:

1. Select the table where you want to create the index.
2. Click the Add Index button.
3. A new index will appear below the table fields.
4. Select the columns to include in the index.
5. Give the index a name and configure its uniqueness if needed.

Once configured, StackRender automatically generates the corresponding SQL statement.

Example SQL Output:

CREATE UNIQUE INDEX "products_name_index"
ON "products" ("name", "sku");