Reputation: 23
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?
Upvotes: 1
Views: 604
Reputation: 88
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;
Upvotes: 1