Object Browser

DBA xPress ›› Features ››
Parent Previous Next

Object Browser


The Object Browser enables users to view details about the objects in a database schema.

Feature Highlights

  Easily view details about objects in a database

  Generate DDL scripts


Table of Contents

  Filter Trees

o   An example filter

o   Setting up a Filter Tree

  Match Elements

o   Object type filter

o   Object type group filter

o   Text Filter


Tutorial Video


Object Browsing

When you first open the object browser from the pragmatic bench you will be greeted with the Connect to Database window. You will need to select a server and database in order to see its objects. After you specify your database you will be taken to the main view of Object Browser.



If you have selected the browse objects option then it will display the list of schema elements for a database that can be viewed, in a tree structure.

The schema elements shown are:

  Tables

  Views

  Synonyms

  Programmability

  Procedures

  Functions

  DDL Triggers

  Assemblies

  Data Types

  XML Schema    Collections

  Rules

  Defaults

  Routes

  Remote Service Bindings

  Broker Priorities

  Storage

  Full Text Catalogs

  Full Text Stop Lists

  File groups

  Partition Functions

  Partition Schemes

  Security

  Users

  Roles

  Application Roles

  Plan Guides

  Service Broker Objects

  Service Message Types

  Service Contracts

  Service Queues

  Services

  Database Roles

  Schemas

  Asymmetric Keys

  Certificates

  Credentials


You can view the schema elements under any of the categories by expanding the tree (by clicking on the '+' next to the category name).


Clicking on a schema element will display its properties in the right hand side of the window, as well as the script used to generate the object:

 

 

This provides an easy format for checking any object in the entire database. By typing into the search box at the top of the object browser window, a quick search for objects is initiated. The results are displayed as a list, and items can be clicked on in the same way that they are with the tree view.

 

The search can be canceled by clicking on the red 'X'. To change the way the search operates, right click on the magnifying glass. The search match types are:

  Object Name Is

  Object Name Contains (the default)

  Schema Name Is

  Schema Name Contains


For more complicated filtering, you can right click on the database node at the top of the tree, and select 'New Filter Tree'. Filtering is described in more detail in the Introduction to the filtering section.