SpiderPravin
SpiderPravin

Reputation: 23

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?

Upvotes: 1

Views: 604

Answers (2)

Hari Prasanth
Hari Prasanth

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

Chris Amelinckx
Chris Amelinckx

Reputation: 4482

PRAGMA table_info(Table_name);

Upvotes: 0

Related Questions