Adding Objects to Code from Object Browser

SQL Query Analyzer Help

SQL Query Analyzer Help

Adding Objects to Code from Object Browser

Use the drag-and-drop feature of Object Browser to add objects to code in the Editor pane.

To add a single object

  1. In Object Browser, expand a server, and then expand a database.

  2. Expand a folder, click the object, and then drag the object to the position in the Editor pane.

For example, to build a query that selects the CategoryID column from the Categories table, type SELECT in the Editor pane and open the folder for the Northwind database. Drag CategoryID to the position following SELECT in the Editor pane.

To add all the objects in a folder

  1. In Object Browser, expand a server, and then expand a database.

  2. Click the folder, and then drag the folder to the Editor pane.

For example, to build a select list that contains all of the columns in the Category table, drag the Columns folder from the Category table to the Editor pane.