Informix IDS - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.5
October 2008 		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
Export Database, Drop Database, Rename Database
Tables
Create Table References, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns

Columns
Column

Column
Indexes

Indexes
Index
Disable Index, Drop Index, Enable Index, Rename Index Columns, Index
Triggers

Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info
SystemTables

SystemTables
SystemTable
Script: SELECT Columns, Data, Info, Row Count
Views

Views
View
Create Trigger, Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Indexes, Info, Row Count
Triggers

Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info
Synonyms

Synonyms
Synonym

Info
Indexes

Indexes
Index
Disable Index, Drop Index, Enable Index, Rename Index Columns, Index
Triggers

Triggers
Trigger
Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info
Procedures
Create Procedure Procedures
Procedure
Drop Procedure Procedure Editor, Columns, Info
SystemProcedures

System Procedures
SystemProcedure

Columns, Info, Procedure Columns, Source
Functions1
Create Function Functions
Function
Drop Function Function Editor, Columns, Info
SystemFunctions1

System Functions
SystemFunction

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 IDS 9 or later




Copyright © 2008 Onseven Software AB. All rights reserved.