SQLite Database Manager v1.9.8.2

API:

Databases [?]

Loading databases...

Create Table

Create View

Database Actions

SQL Examples

SELECT * FROM sqlite_master;

List all tables

Table structure

List indexes

Vacuum database

Database Information

Database name: -

Path to database: -

Size of database: -

Last modified: -

SQLite version: -

SQLite extension: SQLite3

PHP version: 7.4.33

Client version: 1.9.8.2

Tables

Select a database to view tables

Browse

Structure

SQL

Search

Insert

Export

Import

Triggers

Views

Select a table to browse data

Select a table to view structure

SQL Query

Recent Queries

Run a query to see results

Advanced Search

Insert New Row

Export

Format

SQL CSV JSON

Options

Structure Data Add DROP TABLE Use transactions Add comments

Tables to export

CSV Options

Fields terminated by

Fields enclosed by

Fields escaped by

Replace NULL by

Field names in first row Remove CRLF characters

Import

Format

SQL CSV JSON

Options

Create tables if not exist Replace existing data Use transactions

CSV Options

Fields terminated by

Fields enclosed by

Fields escaped by

NULL represented by

Field names in first row

Click to select file

Importing...

Triggers

Views

Ready

Powered by SQLite Database Manager | Page generated in 0.00 seconds

Create Table:

×

Create Index on

×

Index Name

Unique Index

Create Trigger

×

Trigger Name

Timing

Event

FOR EACH ROW

WHEN expression

Trigger Body

Edit Row

×

Insert Row

×

Add Column

×

Column Name

Data Type

NOT NULL UNIQUE

Default Value

Rename Database

×

New Database Name

BLOB Viewer

×