Informix
Informix Tested for version 9+
Overview JDBC Drivers Features Supported Objects Download

Informix

Informix object type support.

The following table shows the database specific support in DbVisualizer for Informix 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
Databases
 Create Database Databases
Catalog
 Export Database[1], Drop Database, Rename Database  
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], Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Script: Script Index, Disable Index, Drop Index, Enable Index, Rename Index Columns, DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor[1], Info
SystemTables
   SystemTables
SystemTable
 Script: Script System Table Data, Columns, Grants, Info, Row Count
Views
   Views
View
 Create Trigger, Export View[1], Script: Script View, Drop View Data, Columns, DDL[1], Grants, Info, Row Count
Columns
   Columns
Column
   Column
Triggers
   Triggers
Trigger
 Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor[1], Info
Synonyms
   Synonyms
Synonym
   Info
Indexes
   Indexes
Index
 Script: Script Index, Disable Index, Drop Index, Enable Index, Rename Index Columns, DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor[1], Info
Procedures
 Create Procedure Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Columns, Grants, Info
SystemProcedures
   System Procedures
SystemProcedure
   Columns, Info, Source
Functions[2]
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Drop Function Function Editor[1], Columns, Info
SystemFunctions[2]
   System Functions
SystemFunction
   Columns, Info, Source
Sequences[2]
 Create Sequence Sequences
Sequence
 Drop Sequence, Rename Sequence Info
DataTypes[2]
   Collection Types, Distinct Types, Opaque Types
Users
   Users
User
   Info
Roles
   Roles
Role
 Drop Role Info
DBA
   DBA
ServerInfo
   Server Info
Sessions
   Sessions
Session
   Disk I/O, Info, Locks
Spaces
   Chunks, Size, Spaces
Space
   Chunks, Info
[1] DbVisualizer Pro
[2] Version 9.0 and later