CODEWITHSUNDEEP
csqlite
brooks94
brooks94

Reputation: 3936

Scheme of virtual table

I have created a table using a virtual table module in the sqlite3 front-end.

I do something like:

CREATE VIRTUAL TABLE mytable USING mymodule();

At which point the module creates a table with--say--3 columns: x, y, and z.

Now when I type:

.schema mytable

I get this echoed back to me:

CREATE VIRTUAL TABLE mytable USING mymodule();

Is there any way to get it to tell me what columns are available: x, y, and z?

Upvotes: 0

Views: 69

Answers (1)

MPelletier
MPelletier

Reputation: 16677

PRAGMA table_info should work for this. (According to the documentation, it will not display fields marked "hidden", however)

Upvotes: 1

Related Questions