Sqlite

De Linuxmemo.

List names and files of attached databases

.databases

List names of tables. If TABLE specified, only list tables matching LIKE pattern TABLE. .tables ?TABLE?

DESCRIBE [table] n'existe pas, il faut utiliser:

.schema TABLENAME