Best answer to the question
Use PRAGMA table_info
This pragma returns one row for each column in the named table. Columns in the result set include the column name, data type, whether or not the column can be NULL, and the default value for the column. The “pk” column in the result set is zero for columns that are not part of the primary key, and is the index of the column in the primary key for columns that are part of the primary key.
Reference:http://www.sqlite.org/pragma.html#pragma_table_info
1 2 3 4 5 6 7 8 |
|
Another answer may also work
.schema [tablename] will show the CREATE statement(s) for a table or tables
1 2 |
|