Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Navigate Between Scripts

The Transact-SQL Editor for offline development provides two useful navigation tools that are familiar to Visual Studio users: Go To Definition and Find All References. For example, you can right-click a table name and use "Find All References" to list all references to the table in the project. You can double-click a search result to go to the specific code file. In this file, you can right-click the table name again, and choose "Go to Definition" to go back to the table definition.

Warning Caution:
The following procedure uses entities created in previous procedures in the Connected Database Development and Project-Oriented Offline Database Development sections.

To navigate between scripts

  1. Expand the Functions folder in Solution Explorer and double-click GetProductsBySupplier.sql .

  2. Right-click Products in this line of code and select Go To Definition

    SELECT * from Products p
  3. Products.sql is automatically opened, showing the location where the Products type is defined.

  4. Go back to GetProductsBySupplier.sql. This time select Find All References in the contextual menu for Products. In the Find Symbol Results pane, you will see a list of locations where the Products table is referenced. Double-clicking any of the search results will bring you to the location of the reference.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.