using sqlite to add a column to table 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;