SQL Server - 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 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 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, Rebuild Index2, 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 Index2, 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, Script: CALL Procedure Editor, Interface Functions Create Function Functions Function Drop Function, Rename Function, Script: CALL Function Editor, Interface DBA   DBA ServerInfo   Server Info Logins   Logins Devices   Database Devices RemoteServers   Remote Servers Processes   Processes ServerRoles   Roles Locks   Locks 1) DbVisualizer Personal 2) Version 9 and 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

---