| Command | Description |
|---|---|
sqlite3 <dbname> |
Create database with name is dbname if dbname does not exist. Otherwise, open the database |
.tables [<table>] |
List all tables, if table is specified just list the tables matching LIKE pattern table |
.schema <table> |
Show table schema |
.dump |
Show database structure and data |
.quit or .exit |
Quit |
.help |
Show all special commands |