SQLite Expert Help
Initializing search
SQLite Expert Help
Home
Introduction
Introduction
Introduction
What's new?
What is SQLite?
What is SQLite Expert?
Feature comparison
Terms and Conditions
ICU License
Ordering
System requirements, installation and registration
Credits
Using SQLite3 databases
Using SQLite3 databases
Using SQLite3 databases
Creating databases
Opening an existing database
Closing a database
Renaming database alias
Displaying database information and internal parameters
Performing maintenance operations
Analyzing disk space usage
Using encrypted databases
Attaching and Detaching databases
Loading and Unloading SQLite extensions
Comparing two databases
Performing an online backup of a database
Editing tables
Editing tables
Editing tables
Creating a table
Editing a table
Renaming a table
Deleting a table or a group of tables
Editing columns
Editing indexes
Editing primary keys
Editing foreign keys
Editing constraints
Editing table triggers
Copying fields, indexes, constraints and triggers using the clipboard
Converting tables to STRICT
Applying the changes after editing a table
Limitations
Editing virtual tables
Editing virtual tables
Editing virtual tables
Creating a virtual table
Editing a virtual table
Renaming a virtual table
Deleting a virtual table
Editing views
Editing views
Editing views
Creating a view
Editing a view
Deleting a view or a group of views
Using SQL scripts
Using SQL scripts
Using SQL scripts
Executing SQL scripts
Explaining a query plan
Finding missing indexes with the Index Advisor
Cancelling the execution of a long-running SQL script
Saving and loading SQL scripts
Query history
Creating a View from an SQL script
Using parameters in SQL scripts
Code Completion
Viewing and editing data
Viewing and editing data
Viewing and editing data
Viewing table data
Editing table data
Finding a value in the database
Working with JSON
The Value Inspector
The Numeric Editor
Editing live queries
Copying data between tables using the clipboard
Using the SQL Query Builder
Using the SQL Query Builder
Using the SQL Query Builder
The Query Builder Layout
Building SQL queries using the Query Builder
Generating Views using the Query Builder
Viewing the schema diagram
Importing and Exporting Data
Importing and Exporting Data
Importing and Exporting Data
Exporting data to Excel
Exporting data to XML
Exporting data to JSON
Exporting data to HTML
Exporting data to Open Document Spreadsheet (ODS)
Exporting data to SQL
Exporting data to a text file
Importing data from a text file
Importing data from JSON, XML, HTML or a spreadsheet
Using the Data Transfer Wizard
Using the Data Transfer Wizard
Using the Data Transfer Wizard
Importing data from another SQLite database
Importing data from a script
Importing data from an ADO data source
Exporting data to another SQLite database
Exporting data to a script
Copying tables between databases using the clipboard
Using Transactions
Using Transactions
Using Transactions
Starting a transaction
Committing a transaction
Rolling back a transaction
Creating a Savepoint
Releasing a Savepoint
Rolling back to a Savepoint
Extending SQLite Expert using Scripting
Extending SQLite Expert using Scripting
Extending SQLite Expert using Scripting
Scripting examples
Lua scripting API
Pascal scripting API
Data types
Open Statements
Changing options
Diagnostics
Portable mode
Getting Help
Getting Help
Getting Help
Integrated Help
SQLite Expert on the Web
SQLite on the Web
Sending feedback
Known Issues
404 - Not found
Back to top