Informix IDS - Database Specific Support

DbVisualizer Logo
DbVisualizer 6.0
July 2007
http://www.dbvis.com
support@dbvis.com


[ Master documentation index ]

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the Informix IDS RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for an Informix IDS database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.

Object Type Actions Viewers
Databases
Create Database Databases
Catalog
Drop Database, Rename Database
Tables
Create Table References, Tables
Table
Alter Table, Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Grants, Indexes, Info, Navigator, Primary Key, References, Row Count, Row Id, Triggers
Columns
Columns
Column
Column
SystemTables
References, SystemTables
SystemTable
Script: SELECT Columns, Data, Info, Row Count
Views
References, Views
View
Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Indexes, Info, Row Count
Synonyms
Synonyms
Synonym
Info
Indexes
Indexes
Index
Disable Index, Drop Index, Enable Index, Rename Index Columns, Info
Triggers
Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger Info, Source
Procedures
Procedures
Procedure
Drop Procedure Columns, Info, Source
Functions1
Functions
Function
Drop Function Columns, Info, Source
Sequences1
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence Info
DataTypes1
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) Informix version 9 or later




Copyright © 2007 Onseven Software AB. All rights reserved.