SQLite3

Print schema

.schema

Rename a table

ALTER TABLE 'old' RENAME TO 'new'

Modify column type

Just use SQLiteBrowser, bro.

1. Click on Database Structure tab.
2. Right click on the table name in Tables and click “Modify Table”.
3. Change types via dropdown.

EZ.