How can I get a fast overview over an table structure in SQLite?

Question

Is there some command like "show columns from TABLENAME"? I only know that .dump command, but that's really dumb in this case. It puts out all the data, too.

I need something to just see the table structure.

Answer 1

select * from sqlite_master

should work I think.

Answer 2

You'll need to use a PRAGMA.

PRAGMA table_info(TABLENAME);