ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== metaColumns =====
~~NOTOC~~
<WRAP right box>
  obj[] metaColumns(
       string $tableName,
       optional bool $normalize=false
       )
</WRAP>
===== Description =====
The function ''metaColumns()'' returns an array of [[v6:dictionary:adofieldobject]] objects, each representing a description of each field of the requested table or view in the passed value ''$tableName''. Each database returns a core set of descriptions, plus additional information. See the driver documentation for more information.

The formatting of the array cannot be controlled by ''ADODB_ASSOC_CASE'', the following casing occurs:

  * Field name (array key) - if the current value of [[v6:reference:adodb_fetch_mode]] is ADODB_FETCH_NUM, then the keys are returned as a numeric array, otherwise they are returned as an Upper Case key containing the name of the field.
  * Information keys - Lower Case
  * Information - Lower Case

===== Usage =====
<code php>
/*
 * Assume DB2 connection
 */
$ar = $db->metaColumns('ACT');
print_r($ar);
/*
 * Returns
Array
(
    [ACTNO] => ADOFieldObject Object
        (
            [name] => ACTNO
            [max_length] => 2
            [type] => I
            [not_null] =>
            [scale] => 0
            [primary_key] => 1
        )

    [ACTKWD] => ADOFieldObject Object
        (
            [name] => ACTKWD
            [max_length] => 6
            [type] => C
            [not_null] =>
            [scale] =>
            [primary_key] =>
        )

    [ACTDESC] => ADOFieldObject Object
        (
            [name] => ACTDESC
            [max_length] => 20
            [type] => C
            [not_null] =>
            [scale] =>
            [primary_key] =>
        )

)
*/
</code>