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

SQLite Alter Table