-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 zhangzhenggui wrote: > When I execute a SQL with C/C++ API, I want to know which table is > operated by this SQL. Is there any way to do this except parse the SQL?
Using "explain" in front of your query will give the byte code and be most complete. If you use "explain query plan" then you'll get a quick listing of tables involved and as a bonus which indices are used to access the table. As an alternate approach you can make an authorizer which you have present while running sqlite3_prepare. That way you'll get details too. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktMtdwACgkQmOOfHg372QQauACg1ws9zX9mkjNQe2bLgHZ9AU9S XpIAoL9JXK5xIsLfHS+VJ1K8+ZCAlSJh =fz3O -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
