v5:dictionary:dropcolumnsql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dictionary:dropcolumnsql [2015/08/29 18:30] – 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> | <WRAP right box> | ||
== See Also == | == See Also == | ||
- | [[dictionary: | + | [[v5:dictionary: |
== Syntax == | == Syntax == | ||
array dropColumnSql( | array dropColumnSql( | ||
Line 13: | Line 13: | ||
The method '' | The method '' | ||
- | In order to actually create the column, the returned array must be passed to the [[dictionary: | + | In order to actually create the column, the returned array must be passed to the [[v5:dictionary:executesqlarray|executeSqlArray()]] method. |
===== Usage ===== | ===== Usage ===== | ||
<code php> | <code php> | ||
+ | /* | ||
+ | * Connection to DB2 database | ||
+ | */ | ||
$dict = NewDataDictionary($db); | $dict = NewDataDictionary($db); | ||
$sqlarray = $dict-> | $sqlarray = $dict-> | ||
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-> | ||
+ | |||
</ | </ | ||
v5/dictionary/dropcolumnsql.1440865819.txt.gz · Last modified: 2017/04/21 11:28 (external edit)