ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== renameColumnSql ======
~~NOTOC~~
<WRAP right box>
== See Also ==
[[v6:dictionary:column_attributes|Column Attributes Reference]] 
== Syntax ==
   array renameColumnSql(
    string $tableName,
    string $oldColumnName,
    string $newColumnName,
    optional string $columnSpec=''
  )
</WRAP>
===== Description =====
The method ''renameColumnSql()'' creates the SQL statement necessary to rename an existing column name given by ''$oldColumnName'' from an existing table, given by ''$tableName'', to a new name, given by ''$newTableName''.

For [[v6:database:mysql#renamecolumnsql|MySQL]] databases, You must provide the entire column specification, given by ''$columnSpec''. Check the manual page for the driver for more information.

In order to actually rename the column, the returned array must be passed to the [[v6:dictionary:executesqlarray|executeSqlArray()]] method. 
----------
===== Usage =====
<code php>
$dict = NewDataDictionary($db);
$sqlarray = $dict->renameColumnSql('ACT','ACTDESC','ACTDESCRIPTION');

print_r($sqlarray);
/*
 * Prints
 Array
(
    [0] => ALTER TABLE ACT RENAME COLUMN ACTDESC TO ACTDESCRIPTION
)

*/
</code>