--- title: "Copy Queries (Visual Database Tools) | Microsoft Docs" ms.custom: "" ms.date: "06/13/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.technology: ssms ms.topic: conceptual helpviewer_keywords: - "copying queries" - "queries [SQL Server], copying" ms.assetid: 46cd1557-cf3d-40b8-b489-8446e0984e0f author: stevestein ms.author: sstein manager: craigg --- # Copy Queries (Visual Database Tools) You can copy the body of a query into a new query to use as a starting point. ### To copy a query 1. From the **View** menu, click Solution Explorer. 2. In Solution Explorer, right-click the query you want to copy and from the shortcut menu choose **Open**. 3. In the SQL pane, copy the portion of the query you want to copy. 4. Create a new query or open the query where you want to paste the copied SQL. 5. Position the cursor where you want to add the SQL code. 6. Right-click and from the shortcut menu click **Paste**. ## See Also [Rename Queries (Visual Database Tools)](visual-database-tools.md) [Clear Query Results (Visual Database Tools)](clear-query-results-visual-database-tools.md) [Save Queries (Visual Database Tools)](save-queries-visual-database-tools.md) [Perform Basic Operations with Queries (Visual Database Tools)](perform-basic-operations-with-queries-visual-database-tools.md)