Sqlite alter table add column

This article is tagged with: Sqlite alter table add column and mysql

sqlite alter table add column

ALTER TABLE table_name ADD COLUMN new_column_name column_type

rename table sqlite

ALTER TABLE existing_table
RENAME TO new_table;

how to change table name in sqlite

alter table table_name
rename to new_table_name;

This article is tagged with: Sqlite alter table add column and mysql