Why am I getting a syntax error in python (sqlite3)?

Question

Why am I getting a syntax error with the following line?

statement = self.sql.execute("DESCRIBE TEST")

I get the following error:

sqlite3.OperationalError: near "DESCRIBE": syntax error

Possible duplicate: http://stackoverflow.com/questions/3330435/is-there-a-sqlite-equivalent-to-mysqls-describe-table — Shubham, Jun 29 '12 at 07:17

score 3 · Accepted Answer · answered Jun 29 '12 at 07:16

3

DESCRIBE is not a valid sqlite3 command, use .schema TEST

answered Jun 29 '12 at 07:16

Uku Loskit

If I do statement = self.sql.execute(".schema TEST") I get: "OperationalError: near ".": syntax error" – Guiste Oct 06 '21 at 06:43
that only works on the sqlite shell I believe – Uku Loskit Oct 13 '21 at 11:07

1 Answers1