Differences

This shows you the differences between two versions of the page.

--- dictionary:dropcolumnsql [2015/08/27 03:13] – created mnewnham
+++ v5:dictionary:dropcolumnsql [2016/01/13 02:06] (current) – ↷ Links adapted because of a move operation mnewnham
@@ Line 3: / Line 3: @@
 <WRAP right box>
 == See Also ==
-[[dictionary:column_attributes|Column Attributes Reference]]
+[[v5:dictionary:column_attributes|Column Attributes Reference]]
 == Syntax ==
   array dropColumnSql(
@@ Line 13: / Line 13: @@
 The method ''dropColumnSql()'' creates the SQL statement necessary to drop an existing column given by ''$columnName'' from an existing table, given by ''$tableName'.
-In order to actually create the column, the returned array must be passed to the [[dictionary:executeSqlArray|executeSqlArray()]] method.
+In order to actually create the column, the returned array must be passed to the [[v5:dictionary:executesqlarray|executeSqlArray()]] method.
 ===== Usage =====
 <code php>
+/*
+* Connection to DB2 database
+*/
 $dict = NewDataDictionary($db);
-$sqlarray = $dict->dropColumnSql('ACT','ACTDESC');
+$sqlarray = $dict->dropColumnSql('ACT','ACTNOTES');
 print_r($sqlarray);
+/*
+ * Prints
+Array
+(
+    [0] => ALTER TABLE ACT DROP COLUMN ACTNOTES
+)
+*/
+$dict->executeSqlArray($executeSqlArray);
 </code>