Return to Answer

formatting!

edit approved Aug 14, 2014 at 6:45

16.1k
11
64
96

If you have the sqlite database, use the sqlite3 command line program and thethese commands:
.tables - to

To list all the tables in the database
.schema tablename - to:

.tables

To show the schema for thea given table
tablename:

.schema tablename

If you have the sqlite database, use the sqlite3 command line program and the commands:
.tables - to list all the tables in the database
.schema tablename - to show the schema for the given table

If you have the sqlite database, use the sqlite3 command line program and these commands:

To list all the tables in the database:

.tables

To show the schema for a given tablename:

.schema tablename

Source Link

answered Jun 12, 2009 at 8:26

Truls Unstad

If you have the sqlite database, use the sqlite3 command line program and the commands:
.tables - to list all the tables in the database
.schema tablename - to show the schema for the given table

Collectives™ on Stack Overflow

Return to Answer