Sybase ASE - 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 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
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
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 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



set showplan

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



Copyright © 2008 Onseven Software AB. All rights reserved.