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

Next revision		Previous revision
Last revisionBoth sides next revision
dictionary:dropcolumnsql [2015/08/27 03:13] – created 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','ACTDESC');+$sqlarray = $dict->dropColumnSql('ACT','ACTNOTES');
  
 print_r($sqlarray); print_r($sqlarray);
 +
 +/*
 + * Prints
 +Array
 +(
 +    [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