DbVisualizer - SQL Server - Database Specific Support

SQL Server - Database Specific Support
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 SQL Server RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a SQL Server 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

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

SystemTables

References, SystemTables

SystemTable

Script: SELECT

Columns, Data, Info, Row Count

Views

References, Views

View

Drop View, Rename View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE

Columns, DDL, Data, Indexes, Info, Row Count

Indexes

Indexes

Index

Drop Index, Rebuild Index¹, Rename Index

Info

Users

Users

Groups

Groups

Group

Info, Users

Types

User Defined Data Types

Triggers

Triggers

Trigger

Drop Trigger

Info, Source

Procedures

Procedures

Procedure

Drop Procedure, Rename Procedure

Interface, Source

Functions

Functions

Function

Drop Function, Rename Function

Interface, Source

DBA

DBA

ServerInfo

Server Info

Logins

Logins

Devices

Database Devices

RemoteServers

Remote Servers

Processes

Processes

ServerRoles

Roles

Locks

Locks

¹⁾ SQL Server version 9 or later

Explain Plan

Explain Plan executes your query and records the plan that the database devises to execute it. By examining this plan, you can find out if the database is picking the right indexes and joining your tables in the most efficient manner. The explain plan feature works much the same as executing SQLs to present result sets, you may highlight statements, run a script or load from file. The explain plan results can easily be compared by using the pin feature in combination with window style presentation.


1	2