[solved] How to get a list of views from an sqlite db
lazarus / 16-Databases

----------------------------------------------------------------------
Joanna · 2023-11-16 13:26

Does anyone know how? I can only find tsqlconnection.gettablenames

----------------------------------------------------------------------
CharlyTango · 2023-11-16 13:44

Since SQLDB does not have a special component to query Metadata
(ZeosDB instead has TZSQLMetadata) just use a simple TSQQuery with one
of these statements.

https://www.sqlite.org/index.html could also help to find a working
statement.

I recommend to test the SQL-Statements with one of the SQLite
Frontends.
I suggest https://sqlitebrowser.org/

----------------------------------------------------------------------
Joanna · 2023-11-16 14:30

Thanks it seems that I need to use sqlite_master to get it to work.