How to read metadata from Sqlite database
The equivalent of, for instance, MySQL describe t1; is

PRAGMA TABLE_INFO(t1);


and

SELECT * FROM sqlite_master WHERE tbl_name = 't1';


is also useful. Most of the time, however, I simply use

.schema t1 


which outputs the SQL definition of the table or view, even with the original comments (exactly the same as SELECT sql FROM sqlite_master WHERE..., with less typing. .sch works too.)