SQLite Alter Table
The SQLite Alter Table Tool allows users to visually alter tables. The Alter Table Tool can generate and/or execute the SQL that corresponds to any table alterations specified by the user.
SQLite does not support many of the typical Alter Table commands that are supported by most databases. For example, adding foreign keys, primary keys, etc. via the alter table syntax are not supported. The following options are available for the SQLite Alter Table Tool.
Add Column - Adds a column to a table
Rename Table - Renames a table
Listed below are some sample SQL statements generated by the Alter Table Tool.
ALTER TABLE employee ADD newcol CHAR(25) NOT NULL
ALTER TABLE employee RENAME TO employee_copy
