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

SQLite Object Tree: Tables

Node "TABLE"

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.  

SQLite tree - table

SELECT Upper(name)  "name"
  FROM $$ATTACHDB.sqlite_master
WHERE Upper(type)='TABLE'
order by Upper(name)

Menu

  • Copy name - copy table name to clipboard

  • reindex - rebuild all indexes built on table columns

  • Get DDL - generate table creation code

select sql 
  from $$ATTACHDB.sqlite_master
where Upper(name)=Upper($$TABLE_NAME)

  • SQL [Select]  - generate a query code for the table and add it to the editor

  • SQL[Insert]  - generate a command code for inserting data into a table and add it to the editor

  • SQL [Delete all rows]  - generate a command code to delete all rows in the table and add to the editor

  • SQL [Rename table]  - generate a command code to change the table name and add it to the editor

  • SQL[Drop]  - generate a code for deleting a table and add it to the editor

  • Show data  - show table data in grid in read-only mode

  • Edit data - show table data in grid in edit mode

  • edittable- 

  • Export data to CSV - launch the wizard for exporting table data to a CSV file

  • Import data from CSV - launch the wizard for importing data from a CSV file into a table

Column Node

List of columns of the selected table with data type

SQLite tree - table column

PRAGMA $$ATTACHDB.table_info($$TABLE_NAME)

Node "Index"

List of indexes based on table columns

SQLite tree - table index list

select name 
  from $$ATTACHDB.sqlite_master
where Upper(tbl_name) = Upper($$TABLE_NAME)
   and Upper(type) = 'INDEX' order by 1

Node "Details"

Displays detailed information on the index

pragma $$ATTACHDB.index_info($$INDEX_NAME)

bottom of page