====== SQL pomůcky ======
Vypsání tabulek v databázi
<code sql>
SELECT name FROM sqlite_master 
WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%'
UNION ALL 
SELECT name FROM sqlite_temp_master 
WHERE type IN ('table','view') 
ORDER BY 1
</code>

Vypsání sloupců v tabulce
<code sql>
PRAGMA table_info(tablename)
</code>

Vytvoření SQL pro tabulky
<code sql>
SELECT sql FROM 
   (SELECT * FROM sqlite_master UNION ALL
    SELECT * FROM sqlite_temp_master)
WHERE type!='meta'
ORDER BY tbl_name, type DESC, name
</code>

===== Command line import =====
<code>
sqlite> .mode csv
sqlite> .separator "\t"
sqlite> .import /cesta/k/souboru TABULKA
</code>