Interface SQLCloudRowsetMetadata

Metadata information for a set of rows resulting from a query

interface SQLCloudRowsetMetadata {
    columns: {
        autoIncrement?: number;
        column?: string;
        database?: string;
        name: string;
        notNull?: number;
        primaryKey?: number;
        table?: string;
        type?: string;
    }[];
    numberOfColumns: number;
    numberOfRows: number;
    version: number;
}

Properties

columns numberOfColumns numberOfRows version

Properties

columns

columns: {
    autoIncrement?: number;
    column?: string;
    database?: string;
    name: string;
    notNull?: number;
    primaryKey?: number;
    table?: string;
    type?: string;
}[]

Columns' metadata

Type declaration

  • OptionalautoIncrement?: number

    Column has autoincrement flag? 1

  • Optionalcolumn?: string

    Original name of the column

  • Optionaldatabase?: string

    Database name

  • name: string

    Column name in query (may be altered from original name)

  • OptionalnotNull?: number

    Column is not nullable? 1

  • OptionalprimaryKey?: number

    Column is primary key? 1

  • Optionaltable?: string

    Database table

  • Optionaltype?: string

    Declare column type

numberOfColumns

numberOfColumns: number

Number of columns

numberOfRows

numberOfRows: number

Number of rows

version

version: number

Rowset version 1 has column's name, version 2 has extended metadata

Settings

Member Visibility

On This Page

Properties