Rename

beware !!: why_alter_table_is_such_a_problem_for_sqlite

Alter table syntax

ALTER TABLE schema.oldname RENAME TO newname.

Primary Key

See How to create or add a Primary Key to a Sqlite Table