SQLITE

Connect to a database:

sqlite3 file.sqlite

List all tables:

.tables

Schema of a given table:

.schema albums

Use the PRAGMA command to display column informations:

.header on
.column on
pragma table_info('albums');

cid  name      type           notnull  dflt_value  pk
---  --------  -------------  -------  ----------  --
0    AlbumId   INTEGER        1                    1
1    Title     NVARCHAR(160)  1                    0
2    ArtistId  INTEGER        1                    0
``