How can one see the structure of a table in SQLite

Question

This question already has an answer here:

• Is there an SQLite equivalent to MySQL's DESCRIBE [table]? 5 answers

How can I see the structure of table in SQLite as desc was in Oracle?

Answer 1

You should be able to see the schema by running

.schema <table>

Answer 2

You can use the Firefox add-on called SQLite Manager to view the database's structure clearly.

Answer 3

I've implemented a SQLite table schema parser in PHP. You may check here: I implemented a sqlite table parser

https://github.com/maghead/sqlite-parser

The syntax follows the SQLite create table statement syntax: http://www.sqlite.org/lang_createtable.html

Answer 4

PRAGMA table_info(table_name);

This will work for both: command-line and when executed against a connected database.

Answer 5

You will get the structure by typing the command:

.schema <tableName>

Answer 6

.schema TableName

Where TableName is the name of the Table