v5:dictionary:createtablesql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dictionary:createtablesql [2015/08/24 01:31] – mnewnham | dictionary:createtablesql [2015/08/27 01:10] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== createTableSql ====== | ====== createTableSql ====== | ||
+ | ~~NOTOC~~ | ||
<WRAP right box> | <WRAP right box> | ||
== See Also == | == See Also == | ||
[[dictionary: | [[dictionary: | ||
+ | |||
+ | [[dictionary: | ||
== Syntax == | == Syntax == | ||
Line 12: | Line 15: | ||
</ | </ | ||
===== Description ===== | ===== Description ===== | ||
- | The method '' | + | The method '' |
===== Parameters ===== | ===== Parameters ===== | ||
==== $tableName ===== | ==== $tableName ===== | ||
The table name must not yet exist in the database. Names must conform to any database specific requirements such as length limitations and name casing. | The table name must not yet exist in the database. Names must conform to any database specific requirements such as length limitations and name casing. | ||
+ | --------- | ||
+ | <WRAP right tip 200px> | ||
+ | $fields is a string, not an array | ||
+ | </ | ||
==== $fields ==== | ==== $fields ==== | ||
A string holding information regarding the columns to create in the new table. For a detailed description of the format of this string, see [[dictionary: | A string holding information regarding the columns to create in the new table. For a detailed description of the format of this string, see [[dictionary: | ||
Line 23: | Line 31: | ||
===== Usage ===== | ===== Usage ===== | ||
<code php> | <code php> | ||
- | + | /* | |
- | + | * create a data dictionary object, using the database | |
- | # Then create a data dictionary object, using this connection | + | */ |
$dict = NewDataDictionary($db); | $dict = NewDataDictionary($db); | ||
Line 37: | Line 45: | ||
/* | /* | ||
- | * create the SQL statement necessary to create the table | + | * create the SQL statement necessary to create the table and its columns |
*/ | */ | ||
$sqlarray = $dict-> | $sqlarray = $dict-> | ||
+ | |||
+ | /* | ||
+ | * This returns (for DB2) | ||
+ | Array | ||
+ | ( | ||
+ | [0] => CREATE TABLE UCTABLE ( | ||
+ | | ||
+ | | ||
+ | | ||
+ | ) | ||
+ | ) | ||
+ | */ | ||
+ | |||
/* | /* |
v5/dictionary/createtablesql.txt · Last modified: 2016/03/05 01:55 by mnewnham