Informix
The following table shows the database specific support in DbVisualizer for Informix organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
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 |
System Tables | SystemTables | |
System Table | 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 |
System Procedures | System Procedures | |
System Procedure | Columns, Info, Source | |
Functions[2] | Create Function | Functions |
Function | Export Function[1], Script: Script Function, Drop Function | Function Editor[1], Columns, Info |
System Functions[2] | System Functions | |
System Function | Columns, Info, Source | |
Sequences[2] | Create Sequence | Sequences |
Sequence | Drop Sequence, Rename Sequence | Info |
Data Types[2] | Collection Types, Distinct Types, Opaque Types | |
Users | Users | |
User | Info | |
Roles | Roles | |
Role | Drop Role | Info |
DBA Views | DBA | |
Server Info | 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 | ||