prorm API Reference
    Preparing search index...

    Interface DropStoredProcedureOptions

    Options for dropping a stored procedure

    interface DropStoredProcedureOptions {
        ifExists?: boolean;
        cascade?: boolean;
        schema?: string;
        paramTypes?: string[];
    }
    Index
    ifExists? cascade? schema? paramTypes?
    ifExists?: boolean

    If true, does not throw error if procedure does not exist

    cascade?: boolean

    If true, also drops dependent objects (CASCADE)

    schema?: string

    Schema (for PostgreSQL)

    paramTypes?: string[]

    Explicit argument type signature for the procedure (e.g. ['VARCHAR', 'NUMBER']). Required by dialects (e.g. Snowflake) whose DROP PROCEDURE syntax must match the exact argument types the procedure was created with, since procedures are overloadable by signature.

    Settings
    Member Visibility

    On This Page
    Properties