Skip to content

lesson-2-6-script-a-table.md

Latest commit

 

History

History
34 lines (24 loc) · 1.9 KB

lesson-2-6-script-a-table.md

File metadata and controls

34 lines (24 loc) · 1.9 KB
title Script a Table | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology ssms
ms.topic conceptual
ms.assetid ea88d736-849e-4368-b55d-06aeee097bf3
author stevestein
ms.author sstein
manager craigg

Script a Table

[!INCLUDEssManStudioFull] can create scripts to select, insert, update, and delete tables, and to create, alter, drop, or execute stored procedures.

Sometimes you want a script with multiple options, such as drop a procedure and then create a procedure, or create a table then alter a table. To create combined scripts, save the first script to a Query Editor window and the second to the clipboard so you can paste it into the window after the first script.

Creating an Update Script

To create the insert script for a table

  1. In Object Explorer, expand your server, expand Databases, expand [!INCLUDEssSampleDBobject], expand Tables, right-click HumanResources.Employee, and then point to Script Table As.

  2. The shortcut menu has seven available scripting options: CREATE To, DROP To, DROP and CREATE To, SELECT To, INSERT To, UPDATE To, and DELETE To. Point to UPDATE To, and then click New Query Editor Window.

  3. A new Query Editor window opens, makes a connection, and presents the entire update statement.

    This exercise demonstrates how the scripting feature can do more than just script the creation of a table or stored procedure. This new feature can help you quickly add data manipulation scripts to your project and easily script execution of stored procedures. This can be a big timesaver for tables and procedures with many fields.

Next Task in Lesson

Summary: Writing Transact-SQL