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.
|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
Expand the Functions folder in Solution Explorer and double-click GetProductsBySupplier.sql .
Productsin this line of code and select Go To Definition
SELECT * from Products p
Products.sql is automatically opened, showing the location where the
Productstype is defined.
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
Productstable is referenced. Double-clicking any of the search results will bring you to the location of the reference.