prorm API Reference
    Preparing search index...

    Interface SequenceOptions

    Options for creating a sequence

    interface SequenceOptions {
        name: string;
        schema?: string;
        startWith?: number;
        minvalue?: number;
        maxvalue?: number;
        incrementBy?: number;
        cycle?: boolean;
        cache?: number;
        ifNotExists?: boolean;
        replace?: boolean;
        temporary?: boolean;
        ownedBy?: string;
        order?: boolean;
        nocache?: boolean;
    }
    Index
    name schema? startWith? minvalue? maxvalue? incrementBy? cycle? cache? ifNotExists? replace? temporary? ownedBy? order? nocache?
    name: string

    Sequence name

    schema?: string

    Schema (for PostgreSQL)

    startWith?: number

    Starting value

    minvalue?: number

    Minimum value

    maxvalue?: number

    Maximum value

    incrementBy?: number

    Increment value

    cycle?: boolean

    Whether sequence cycles

    cache?: number

    Cache size

    ifNotExists?: boolean

    If true, uses CREATE SEQUENCE IF NOT EXISTS

    replace?: boolean

    If true, uses CREATE OR REPLACE

    temporary?: boolean

    Temporary sequence (exists only for session)

    ownedBy?: string

    Owned by a column

    order?: boolean

    Force ordering (Oracle)

    nocache?: boolean

    No cache (Oracle)

    Settings
    Member Visibility

    On This Page
    Properties