How do you rename a table in SQLite 3.0?

Question

How do you rename a table in SQLite 3.0?

Answer 1

ALTER TABLE foo RENAME TO bar

Answer 2

Don't forget that SQLite has a decent online SQL reference that covers these types of commands:

http://www.sqlite.org/lang_altertable.html