How can one see the structure of a table in SQLite

Question

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

User · Answer

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

User · Answer

You can query sqlite master  SELECT sql FROM sqlite master WHERE name  foo     which will return a create table SQL statement  for example     sqlite3 mydb sqlite sqlite gt  create table foo  id int primary key  name varchar 10    sqlite gt  select sql from sqlite master where name  foo   CREATE TABLE foo  id int primary key  name varchar 10    sqlite gt   schema foo CREATE TABLE foo  id int primary key  name varchar 10     sqlite gt  pragma table info foo  0 id int 0  1 1 name varchar 10  0  0

User · Answer

You should be able to see the schema by running   schema  lt table gt

User · Answer

If you are using PHP you can get it this way    lt  php      dbname    base db        db   new SQLite3  dbname        sturturequery    db- gt query  SELECT sql FROM sqlite master WHERE name  foo           table    sturturequery- gt fetchArray        echo   lt pre gt      table  sql       lt  pre gt          db- gt close      gt

User · Answer

PRAGMA table info table name     This will work for both  command-line and when executed against a connected database   A link for more details and example  thanks SQLite Pragma Command

User · Answer

schema TableName  Where TableName is the name of the Table

User · Answer

You will get the structure by typing the command    schema  lt tableName gt

User · Answer

Invoke the sqlite3 utility on the database file  and use its special dot commands     tables will list tables  schema  tablename  will show the CREATE statement s  for a table or tables   There are many other useful builtin dot commands -- see the documentation at http   www sqlite org sqlite html  section Special commands to sqlite3   Example   sqlite gt  entropy   Library Mail gt sqlite3 Envelope  Index SQLite version 3 6 12 Enter   help  for instructions Enter SQL statements terminated with a     sqlite gt   tables addresses              ews folders            subjects alarms                 feeds                  threads associations           mailboxes              todo notes attachments            messages               todos calendars              properties             todos deleted log events                 recipients             todos server snapshot sqlite gt   schema alarms CREATE TABLE alarms  ROWID INTEGER PRIMARY KEY AUTOINCREMENT  alarm id                       todo INTEGER  flags INTEGER  offset days INTEGER                       reminder date INTEGER  time INTEGER  argument                       unrecognized data BLOB   CREATE INDEX alarm id index ON alarms alarm id   CREATE INDEX alarm todo index ON alarms todo     Note also that SQLite saves the schema and all information about tables in the database itself  in a magic table named sqlite master  and it s also possible to execute normal SQL queries against that table  For example  the documentation link above shows how to derive the behavior of the  schema and  tables commands  using normal SQL commands  see section  Querying the database schema

[sqlite] How can one see the structure of a table in SQLite?

Examples related to sqlite