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:







  DDL Triggers


  Data Types

  XML Schema    Collections




  Remote Service Bindings

  Broker Priorities


  Full Text Catalogs

  Full Text Stop Lists

  File groups

  Partition Functions

  Partition Schemes




  Application Roles

  Plan Guides

  Service Broker Objects

  Service Message Types

  Service Contracts

  Service Queues


  Database Roles


  Asymmetric Keys



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.