top of page

SQL developer for SQLite

Открытая·2 пользователя

SQLite: tree objects [Options]



[EN]

Parameters for working with SQLite databases. When you select a specific database, additional information on the parameters of the selected database is displayed


No base selected

  • PRAGMA automatic_index

  • PRAGMA busy_timeout


19 просмотров

SQLite: tree objects [Views]



[EN]

List of views in connected SQLite databases. Allows you to quickly navigate the database structure, perform various view maintenance operations, and view the structure and data.


select name

  from $$ATTACHDB.sqlite_master


9 просмотров

SQLite: tree objects [Indexes]



[EN]

List of indexes in connected SQLite databases. Allows you to quickly navigate the database structure, perform various index maintenance operations, and view the structure and data.


select name

  from $$ATTACHDB.sqlite_master


8 просмотров

SQLite: tree objects [Tables]



[EN]

List of tables in connected SQLite databases. Allows you to quickly navigate the database structure, perform various table maintenance operations, view the structure and data


SELECT Upper(name) "name"

  FROM $$ATTACHDB.sqlite_master


10 просмотров

Участники

bottom of page