Interface IndexColumn

Index column definition with optional expression

interface IndexColumn {
    name: string;
    expression?: ExpressionPart;
    length?: number;
    order?: "ASC" | "DESC";
}

Index

Properties

name expression? length? order?

Properties

name

name: string

Column name

`Optional`expression

expression?: ExpressionPart

Optional expression for functional index

`Optional`length

length?: number

Optional length for prefix index

`Optional`order

order?: "ASC" | "DESC"

Sort order