Skip to content

how-to-navigate-between-scripts.md

Latest commit

 

History

History
37 lines (27 loc) · 1.83 KB

how-to-navigate-between-scripts.md

File metadata and controls

37 lines (27 loc) · 1.83 KB
title Navigate Between Scripts
ms.prod sql
ms.technology ssdt
ms.topic conceptual
f1_keywords
sql.data.tools.editor.howto.navigate
ms.assetid 8664bde5-86ff-4e8b-b5a6-af003316f6ad
author markingmyname
ms.author maghan
manager jroth
ms.reviewer “”
ms.custom seo-lt-2019
ms.date 02/09/2017

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

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.