SQL Server - 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 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
Export 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
Drop Index, Rebuild Index1, Rename Index Index
Triggers

Triggers
Trigger
Drop Trigger Trigger Editor, Info, Source
SystemTables

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

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

Triggers
Trigger
Drop Trigger Trigger Editor, Info, Source
Indexes

Indexes
Index
Drop Index, Rebuild Index1, Rename Index Index
Users

Users
Groups

Groups
Group

Info, Users
Types

User Defined Data Types
Triggers

Triggers
Trigger
Drop Trigger Trigger Editor, Info, Source
Procedures
Create Procedure Procedures
Procedure
Drop Procedure, Rename Procedure Procedure Editor, Interface
Functions
Create Function Functions
Function
Drop Function, Rename Function Function Editor, Interface
DBA

DBA
ServerInfo

Server Info
Logins

Logins
Devices

Database Devices
RemoteServers

Remote Servers
Processes

Processes
ServerRoles

Roles
Locks

Locks
1)SQL Server 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

Copyright © 2008 Onseven Software AB. All rights reserved.