alter table sqlite code example

Example 1: sqlite alter table add column

ALTER TABLE table_name ADD COLUMN new_column_name column_type

Example 2: Add colum sqlite table

ALTER TABLE employees
  ADD status VARCHAR;

Example 3: rename table sqlite

ALTER TABLE existing_table
RENAME TO new_table;

Example 4: how to change table name in sqlite

alter table table_name
rename to new_table_name;