Sybase ASE - Database Specific Support

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the Sybase Adaptive Server Enterprise RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a Mimer 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     Catalog Export Database   Tables Import Table Data, Create Table References, Tables Table Export 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, Navigator1, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers Columns   Columns Column   Column Indexes   Indexes Index Drop Index Index Triggers   Triggers Trigger Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info SystemTables   SystemTables SystemTable Script: SELECT Columns, Data, Info, Row Count Views   Views View Drop View, Rename View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Indexes, Info, Row Count Users Add User Users User Drop User Info Groups Add Group Groups Group Drop Group Info, Users Types   User Defined Data Types Triggers   Triggers Trigger Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info Procedures Create Procedure Procedures Procedure Drop Procedure, Rename Procedure, Script: CALL Procedure Editor, Interface DBA   DBA ServerInfo   Character Set, Server Info Logins Create Login Logins Login Change Password, Drop Login Databases, Info, Roles Devices   Database Devices Device   Databases, Info RemoteServers   Remote Servers Processes   Processes ServerRoles   Roles ServerRole   Info, Logins Transactions   Transactions Locks   Locks 1) DbVisualizer Personal

set showplan DbVisualizer captures any output produced by the set showplan SQL statement and displays it in the SQL Commander log.

---