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