Polyglot SQL API Documentation - v0.1.0
    Preparing search index...

    Type Alias Delete

    DELETE statement

    type Delete = {
        alias: Identifier | null;
        alias_explicit_as: boolean;
        force_index: string | null;
        joins: Join[];
        leading_comments: string[];
        limit: Expression | null;
        no_from: boolean;
        on_cluster?: OnCluster | null;
        order_by: OrderBy | null;
        output: OutputClause | null;
        returning: Expression[];
        table: TableRef;
        tables: TableRef[];
        tables_from_using: boolean;
        using: TableRef[];
        where_clause: Where | null;
        with: With | null;
    }
    Index

    Properties

    alias alias_explicit_as force_index joins leading_comments limit no_from on_cluster? order_by output returning table tables tables_from_using using where_clause with

    Properties

    alias: Identifier | null

    Optional alias for the table

    alias_explicit_as: boolean

    Whether the alias was declared with explicit AS keyword

    force_index: string | null

    FORCE INDEX hint (MySQL): DELETE FROM t FORCE INDEX (idx)

    joins: Join[]

    JOINs in MySQL multi-table DELETE: DELETE t1 FROM t1 LEFT JOIN t2 ...

    leading_comments: string[]

    Leading comments before the statement

    limit: Expression | null

    LIMIT clause (MySQL)

    no_from: boolean

    BigQuery-style DELETE without FROM keyword: DELETE table WHERE ...

    on_cluster?: OnCluster | null

    ClickHouse: ON CLUSTER clause for distributed DDL

    order_by: OrderBy | null

    ORDER BY clause (MySQL)

    output: OutputClause | null

    OUTPUT clause (TSQL)

    returning: Expression[]

    RETURNING clause (PostgreSQL)

    table: TableRef
    tables: TableRef[]

    MySQL multi-table DELETE: DELETE t1, t2 FROM ... or DELETE FROM t1, t2 USING ... These are the target tables to delete from

    tables_from_using: boolean

    True if tables were after FROM keyword (DELETE FROM t1, t2 USING syntax) False if tables were before FROM keyword (DELETE t1, t2 FROM syntax)

    using: TableRef[]

    PostgreSQL/DuckDB USING clause - additional tables to join

    where_clause: Where | null
    with: With | null

    WITH clause (CTEs)

    Settings

    Member Visibility

    On This Page

    Properties