SQL - Alter Table

GSAK (Geocaching Swiss Army Knife)

SQL - Alter Table

Warning: The SQL command was the first introduction of SQL to the macro language. It has many limitations and quirks and is now deprecated. It is provided for here for backwards compatibility only. It is very much recommended that you use the more complete and robust SQLite database engine. See the SQLite() function.

Allows you to alter the structure of a table.

Syntax:

ALTER TABLE ADD COLUMN fieldname
ALTER TABLE DROP COLUMN filedname

You can only add or drop one field at the time. Please see SQL - Quirks for naming restrictions on field names.