Differences

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

--- v5:dictionary:changetablesql [2016/01/13 02:06] – ↷ Links adapted because of a move operation mnewnham
+++ v5:dictionary:changetablesql [2025/08/17 02:04] (current) – [$tableName] mnewnham
@@ Line 20: / Line 20: @@
 ===== Parameters =====
 ==== $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>
@@ Line 26: / Line 26: @@
 </WRAP>
 ==== $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 [[v5:dictionary:addcolumnsql|addColumnSql()]].
+A string holding information regarding the columns to create in the new table. For a detailed description of the format of this string, see [[v5:dictionary:column_attributes]].
 ==== $tableOptions ====
 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 ====
-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 =====
 <code php>
@@ Line 44: / Line 44: @@
 $flds = "
-   COL1 C(60) NOTNULL DEFAULT 'abc',
+   COL1 C(60) NOTNULL DEFAULT 'abc'
   ";
@@ Line 56: / Line 56: @@
 Array
 (
-    [0] =>  ALTER TABLE LCTABLE ALTER COLUMN COL1 SET DATA TYPE VARCHAR(60) DEFAULT 'abc'
+    [0] =>  ALTER TABLE LCTABLE
+            ALTER COLUMN COL1 SET DATA TYPE VARCHAR(60) DEFAULT 'abc'
 )
 */