====== addColumnSql ======
~~NOTOC~~
<WRAP right box>
== See Also ==
[[v5:dictionary:column_attributes|Column Attributes Reference]] 
== Syntax ==
  array addColumnSql(
      string $tableName,
      string $columnData
      )
</WRAP>
===== Description =====
The method ''addColumnSql()'' creates the SQL statement necessary to add one or more columns to an existing table, given by ''$tableName'', with the attributes specified in the string ''$columnData''. The column(s) must not already exist in the specified table. To add multiple columns, separate each column specification with a ','.

The information specified in the ''$columnData'' string must conform to the [[v5:dictionary:column_attributes|Column Attributes]] standard.

In order to actually create the column, the returned array must be passed to the [[v5:dictionary:executesqlarray|executeSqlArray()]] method. 

===== Usage =====
<code php>
/*
 * Connecting to IBM DB2 database
*/

/*
 * Create dictionary object
*/
$dict = NewDataDictionary($db);
/*
 * Add 2 new columns to table
*/
$columns = 'ACTNOTES X, ACTMAXSALE N 12.2';
$sqlarray = $dict->addColumnSql('ACT',$columns);

print_r($sqlarray);

/*
 * Prints
Array
(
 [0] => ALTER TABLE ACT ADD ACTNOTES VARCHAR(3600)
 [1] => ALTER TABLE ACT ADD ACTMAXSALE DECIMAL(12,2)
)
*/

/*
 * Now execute the statements to actually create the columns
 */
$ok = $dict->executeSqlArray($sqlarray);
</code>