Skip to content
Advertisement

Table description in Sqlite expert database

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;

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement