SQLite
SQLite Tested for version 3.6+
Overview JDBC Drivers Features Supported Objects Download

SQLite

SQLite object type support.

The following table shows the database specific support in DbVisualizer for SQLite organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Schema
 Export Schema[1] References, Tables
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Create Index, Drop Table, Empty Table, Rename Table Navigator[1], References, Data, Columns, DDL[1], Indexes, Info, Native DDL, Primary Key, Row Count, Row Id
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Views
   Views
View
 Export View[1], Script: Script View, Drop View Data, DDL[1], Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
[1] DbVisualizer Pro
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗