SQLite - Table
About
What is a Table in SQL? in SQLite.
Management
Rename
beware !!: why_alter_table_is_such_a_problem_for_sqlite
ALTER TABLE schema.oldname RENAME TO newname.
Primary Key
See How to create or add a Primary Key to a Sqlite Table