IndexColumnOptions

Options for column within an index, supporting advanced index features like prefix length and collation.

Index

Properties

• collation
• length
• name
• nulls
• sort

Properties

optionalcollation

collation?: string

Collation for the column (PostgreSQL, SQLite, or MySQL/MariaDB via expression).

optionallength

length?: number

Prefix length for the column (MySQL, MariaDB).

name

name: string

Column name or property path.

optionalnulls

nulls?: first | last | FIRST | LAST

NULLS ordering for the column (PostgreSQL).

optionalsort

sort?: ASC | DESC | asc | desc

Sort order for the column (default: ASC).