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/05/05 01:23] (current) – [$dropColumns] mnewnham
@@ 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'
   ";