Shareware software
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.
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
PRAGMA $$ATTACHDB.table_info($$TABLE_NAME)
Node "Index"
List of indexes based on table columns
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)