Object Browser

SQL Query Analyzer Help

SQL Query Analyzer Help

Object Browser

Use Object Browser to navigate the database objects of the selected database server. Object Browser is accessible through a button on the toolbar and through the Object Browser command on the Tools menu.

The Objects tab contains a tree list that displays the databases in the selected database server. For each database, Object Browser lists these folders.

User Tables For each user table, Object Browser lists columns, indexes, triggers, and dependencies.
System Tables For each system table, Object Browser lists the columns, indexes, and dependencies.
Views For each view, Object Browser lists the columns and dependencies.
Stored Procedures For each stored procedure, Object Browser lists parameters and dependencies.
Extended Stored Procedures For each extended stored procedure, Object Browser lists parameters and dependencies.

Extended stored procedures are shown only for the master database.

Functions For each user-defined function, Object Browser lists parameters and dependencies.

In addition to databases, the tree list displays a folder named Common Objects, which contains Transact-SQL built-in functions and base data types.

The Templates tab displays the templates stored in the Query Analyzer Templates directory.