How to get the table description in Sqlite Expert Professional? I tried:
x
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?
Advertisement
Answer
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;