sqlite alter table add column code example

Example 1: sqlite alter table add column

ALTER TABLE table_name ADD COLUMN new_column_name column_type

Example 2: rename table sqlite

ALTER TABLE existing_table
RENAME TO new_table;

Example 3: how to change table name in sqlite

alter table table_name
rename to new_table_name;