Differences

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

--- v5:dictionary:changetablesql [2024/08/31 16:19] – [$fields] link directly to column attributes page dregad
+++ 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 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.
 ==== $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'
   ";