Test that a table exists in Luasqlite

Question

I'm using Luasqlite.

If I wanted to write a test to verify that a table exists, that returns boolean, how would I go about doing it?

It seems if I try selecting something from a table that doesn't exist, as my test, then the application errors out altogether.

Thank you!

Answer 1

You can execute the 'table_info' pragma.

db:exec("pragma table_info('Publication');") --check for table 'Publication'