top of page
Shareware software


SQLite Object Tree: Views
List Views in Connected Databases SQLite. Allows you to quickly navigate the structure of the database, perform various operations of view maintenance, view the structure and data.

select name
from $$ATTACHDB.sqlite_master
where Upper(type) = 'VIEW'
order by 1
Menu
-
Source - generate the view creation code and add it to the editor
select sql
from $$ATTACHDB.sqlite_master
where Upper(name)=Upper($$VIEW_NAME)
-
Data - show view data
bottom of page