AskSQL API Reference (core v0.10.0)
    Preparing search index...

    Interface TableInfo

    interface TableInfo {
        checks: readonly string[];
        columns: readonly ColumnInfo[];
        comment?: string | null;
        definition?: string | null;
        foreignKeys: readonly ForeignKeyInfo[];
        indexes: readonly IndexInfo[];
        isPartitioned?: boolean;
        kind: "table" | "view" | "materialized_view";
        name: string;
        partitionOf?: string | null;
        primaryKey: readonly string[];
        rowEstimate?: number | null;
        schema?: string;
        source?: "db" | "file";
        uniques: readonly (readonly string[])[];
    }
    Index
    checks columns comment? definition? foreignKeys indexes isPartitioned? kind name partitionOf? primaryKey rowEstimate? schema? source? uniques
    checks: readonly string[]
    columns: readonly ColumnInfo[]
    comment?: string | null
    definition?: string | null

    View / matview definition SQL (read-only DDL display).

    foreignKeys: readonly ForeignKeyInfo[]
    indexes: readonly IndexInfo[]
    isPartitioned?: boolean
    kind: "table" | "view" | "materialized_view"
    name: string
    partitionOf?: string | null

    Parent table when this relation is a partition (collapsed by default).

    primaryKey: readonly string[]
    rowEstimate?: number | null
    schema?: string
    source?: "db" | "file"

    'file' for tables created from uploads (DuckDB), 'db' otherwise.

    uniques: readonly (readonly string[])[]

    Settings
    Member Visibility

    On This Page
    Properties