Table description in Sqlite expert database

Question

How to get the table description in Sqlite Expert Professional? I tried:

Desc Table_name
exec sp_help Table_name
sp_columns Table_name
sp_help Table_name
Execute sp_help Table_name

All commands return nothing, except of an error message. What is the correct command?

Similar question: http://stackoverflow.com/questions/3330435/is-there-a-sqlite-equivalent-to-mysqls-describe-table — Stefan Steinegger, Jul 28 '15 at 11:52

score 1 · Accepted Answer · answered Feb 04 '21 at 12:36

1

I really think SQLite hates me - so instead of the query being

PRAGMA table_info('member');

I now used

SELECT * FROM member WHERE 1 = 2;

answered Feb 04 '21 at 12:36

Hari Prasanth

score 0 · Answer 2 · answered Jul 05 '18 at 20:35

0

PRAGMA table_info(Table_name);

answered Jul 05 '18 at 20:35

Chris Amelinckx

2 Answers2