Pike v8.0 release 1738

Method Sql.tds()->big_query()->fetch_fields()


Method fetch_fields

array(mapping(string:mixed)) fetch_fields()

Description

Fetch a description of the fields in the result.

Returns

Returns an array with a mapping for each of the fields in the result.

The mappings contain the following information:

  • Standard fields:

    "name" : string

    The name of the field.

    "table" : string|void

    The name of the table (if available).

  • TDS-specific fields:

    "nullable" : bool

    1 if the field may contain NULL.

    "writeable" : bool

    1 if the field may be changed.

    "identity" : bool

    1 if the field is the identity for the row.

    "column_size" : int

    Width of the field.

    "timestamp" : bool

    Time stamp information for last change is available.

    "column_prec" : int|void

    Precision of the field.

    "column_scale" : int|void

    Scale exponent of the field.

    "usertype" : int

    Internal use only.

    "flags" : int
    "column_type" : int
    "cardinal_type" : int
    "varint_size" : int