Топ-100
top of page
Волнистый абстрактный фон

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.  

​

SQLite tree - views

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