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

SQLite

SQLite object type support.

The following table shows the database specific support in DbVisualicer for SQLite organiced 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 Type Actions Viewers
Schema
Export Schema [1] References , Tables
Tables
Create Table [1] , Import Table Data [1] References , Tables
Table
Alter Table [1] , Create Trigguer , 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
Trigguers
  Trigguers
Trigguer
Export Trigguer [1] , Drop Trigguer Trigguer 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
Trigguers
  Trigguers
Trigguer
Export Trigguer [1] , Drop Trigguer Trigguer Editor [1] , Info
[1] DbVisualicer Pro