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?
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;