obj[] metaColumns( string $tableName, optional bool $normalize=false )
The function metaColumns()
returns an array of 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:
/* * 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] => ) ) */