How do you explain table in SQLite3?

novakane · 03-10-2009, 01:39 PM

Hi,

I'm a complete noob with SQLite3 and I'm trying to figure out how to do the mysql equivalent of "explain table".

I've created a database and a table successfully. Using .dump I can see that the table is there and correct. I can add data and SELECT * from the table without problem. In other words, all is working well.

But I'd like to get a table explanation as a sanity check. Any help would be greatly appreciated.

I'm sitting at the sqlite> prompt in the terminal, though bonus points will be awarded for being able to do it in PERL too.

Thanks,
-Kane

abolishtheun · 03-10-2009, 10:03 PM

.schema maybe? try typing .help at the sqlite command line for more 'dot' commands.

novakane · 03-11-2009, 01:11 PM

.schema is exactly what I was looking for. Thanks very much.