ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:dropcolumnsql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
dictionary:dropcolumnsql [2015/08/29 18:30] – mnewnhamv5:dictionary:dropcolumnsql [2016/01/13 02:06] – ↷ Page moved from dictionary:dropcolumnsql to v5:dictionary:dropcolumnsql mnewnham
Line 17: Line 17:
 ===== Usage ===== ===== Usage =====
 <code php> <code php>
 +/*
 +* Connection to DB2 database
 +*/
 $dict = NewDataDictionary($db); $dict = NewDataDictionary($db);
 $sqlarray = $dict->dropColumnSql('ACT','ACTNOTES'); $sqlarray = $dict->dropColumnSql('ACT','ACTNOTES');
Line 22: Line 25:
 print_r($sqlarray); print_r($sqlarray);
  
 +/*
 + * Prints
 Array Array
 ( (
     [0] => ALTER TABLE ACT DROP COLUMN ACTNOTES     [0] => ALTER TABLE ACT DROP COLUMN ACTNOTES
 ) )
 +
 +*/
 +
 +$dict->executeSqlArray($executeSqlArray);
 +
  
 </code> </code>
  
v5/dictionary/dropcolumnsql.txt · Last modified: 2016/01/13 02:06 by mnewnham