[sqlite] How to read column names

[Eugen Stoianovici]

Is there a way of reading the names of the columns in a table? how about 
the table names in a data base?