Is there an updated query to view the tables of the compact database in SQL 2022?

Steak_From_Jake_Farm

The previous query no longer works in SQL 2022 :

EXEC master..sqbdata 'SELECT * FROM INFORMATION_SCHEMA.TABLES'

It gives the below error : 

no such table: INFORMATION_SCHEMA.TABLES

squigley

Thanks for your inquiry with Redgate SQL Backup.
Unfortunately, there isn't a recommended way to retrieve the list of tables from SQLite using the SQL Backup Agent service as a proxy. You would need to use an SQLite IDE to explore the SQLite database.
Please let us know if you have any other questions or concerns.