Is there an SQLite equivalent to MySQL s DESCRIBE table

Question

I m just getting started learning SQLite  It would be nice to be able to see the details for a table  like MySQL s DESCRIBE  table   PRAGMA table info  table  isn t good enough  as it only has basic information  for example  it doesn t show if a column is a field of some sort or not   Does SQLite have a way to do this

User · Answer

If  you re using a graphical tool  It shows you the schema right next to the table name  In case of DB Browser For Sqlite  click to open the database top right corner   navigate and open your database  you ll see the information populated in the table as below        right click on the record table name  click on copy create statement and there you have it     Hope it helped some beginner who failed to work with the commandline

User · Answer

To prevent that people are mislead by some of the comments to the other answers    If  schema or query from sqlite master not gives any output  it indicates a non-existent tablename  e g  this may also be caused by a   semicolon at the end for  schema    tables      Or just because the table really not exists  That  schema just doesn t work is very unlikely and then a bug report should be filed at the sqlite project            schema can only be used from a command line  the above commands   can be run as a query through a library  Python  C   etc         Mark Rushakoff Jul 25  10 at 21 09      can only be used from a command line  may mislead people  Almost any  likely every   programming language can call other programs commands  Therefore the quoted comment is unlucky as calling another program  in this case sqlite  is more likely to be supported than that the language provides a wrapper library for every program  which not only is prone to incompleteness by the very nature of the masses of programs out there  but also is counter acting single-source principle  complicating maintenance  furthering the chaos of data in the world

User · Answer

To see all tables    tables   To see a particular table    schema  tablename

User · Answer

PRAGMA table info  tablename

User · Answer

The SQLite command line utility has a  schema TABLENAME command that shows you the create statements

User · Answer

Are you looking for the SQL used to generate a table   For that  you can query the sqlite master table   sqlite gt  CREATE TABLE foo  bar INT  quux TEXT   sqlite gt  SELECT   FROM sqlite master  table foo foo 2 CREATE TABLE foo  bar INT  quux TEXT  sqlite gt  SELECT sql FROM sqlite master WHERE name    foo   CREATE TABLE foo  bar INT  quux TEXT

[mysql] Is there an SQLite equivalent to MySQL's DESCRIBE [table]?

Examples related to mysql

Examples related to sqlite