How can we help you today? How can we help you today?

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

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
cmotter
0

Comments

1 comment

Sort by
  • 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.

    squigley
    0

Add comment

Please sign in to leave a comment.