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.

score 55 · Accepted Answer · answered Apr 06 '09 at 13:01

55

You'll need to use a PRAGMA.

PRAGMA table_info(TABLENAME);

answered Apr 06 '09 at 13:01

DNS

37,249
18
95
132

Thanks, I was looking for a command to serve the same purpose as the "Show Columns from tablename" command that I can use when I'm working with mysql. when working with sqlite instead, and this does the job nicely – Kit Ramos Jul 25 '12 at 15:33

score 10 · Answer 2 · answered Apr 06 '09 at 13:01

10

select * from sqlite_master

should work I think.

answered Apr 06 '09 at 13:01

Mladen Mihajlovic

6,095
7
40
55

score 6 · Answer 3 · answered Mar 05 '13 at 03:05

6

in SQLite 3, do:

.schema TABLENAME

answered Mar 05 '13 at 03:05

Juan Rada-Vilela

195
1
8

score 0 · Answer 4 · answered Feb 08 '14 at 09:04

0

Another way, you can use SQLite Manager Add-on for Firefox

https://addons.mozilla.org/vi/firefox/addon/sqlite-manager/

answered Feb 08 '14 at 09:04

Frank Nguyen

6,493
3
38
37

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

4 Answers4

Linked