Sqlite

From DWIKI

Links

Cheatsheetje

Select all from table

select * from mytable;

Describe table

.schema mytable

FAQ

Check integrity

PRAGMA integrity_check;