ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:changetablesql

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
v5:dictionary:changetablesql [2024/11/29 14:08] – [Usage] remove trailing comma in $flds definition (incorrect syntax) dregadv5:dictionary:changetablesql [2025/08/17 02:04] (current) – [$tableName] mnewnham
Line 20: Line 20:
 ===== 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 may or may not exist in the database. If it does not, then the method automatically calls [[v5:dictionary:createtablesql]]. Names must conform to any database specific requirements such as length limitations and name casing.
 --------- ---------
 <WRAP right tip 200px> <WRAP right tip 200px>
Line 30: Line 30:
 An optional array of information that adds information regarding the table creation. This array may also contain field specific information, for example information pertaining to auto-increment fields. An optional array of information that adds information regarding the table creation. This array may also contain field specific information, for example information pertaining to auto-increment fields.
 ==== $dropColumns ==== ==== $dropColumns ====
-By default, any columns not specified in the ''$fields'' parameter are not changed. If the value of ''$dropColumns'' is set to true, then any column not specified in that value will be dropped.+By default, any columns not specified in the ''$fields'' parameter are not changed. If the value of ''$dropColumns'' is set to true, then any column not specified in that value will be dropped. The assumption when using this parameter is that you have you have provided the entire table specification. If you have not, then you may cause serious problems in the table.
 ===== Usage ===== ===== Usage =====
 <code php> <code php>
v5/dictionary/changetablesql.1732885729.txt.gz · Last modified: by dregad