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

Uku Loskit · Accepted Answer · 2012-06-29 07:16:38Z

3

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

answered Jun 29, 2012 at 7:16

Uku Loskit

42.2k9 gold badges97 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

If I do statement = self.sql.execute(".schema TEST") I get: "OperationalError: near ".": syntax error"

that only works on the sqlite shell I believe