SQLite Views

Databases
1

How can I enumerate through the views in an SQLite database. TableSchema does nt include views, and the ExtendedSchema property does not exist for SQLite databases?

2

just run a select on sqlite_master like

select * from sqlite_master where type = ‘view’

3

Thank you very much Norman. The following code does the trick.

dim views as recordset
sql = "select * from sqlite_master where type = 'view'"
views = dbSQLite.SQLselect(sql)