how-to-view-and-edit-data-in-a-table.md

title	View and Edit Data in a Table
ms.prod	sql
ms.technology	ssdt
ms.topic	conceptual
f1_keywords	SQL.DATA.TOOLS.QUERYRESULTS.F1 sql.data.tools.queryresults.executequerydeletingrow
ms.assetid	bb67ce83-a87a-4e14-84cd-9a5930fe74c8
author	markingmyname
ms.author	maghan
manager	jroth
ms.reviewer	“”
ms.custom	seo-lt-2019
ms.date	02/09/2017

How to: View and Edit Data in a Table

You can view, edit, and delete data in an existing table by using a visual Data Editor.

Warning

The following procedures uses entities created in previous procedures in the Connected Database Development section.

To edit data in a table visually using the Data Editor

1. Right-click the Products table in SQL Server Object Explorer, and select View Data.

2. The Data Editor launches. Notice the rows we added to the table in previous procedures.

3. Right-click the Fruits table in SQL Server Object Explorer, and select View Data.

4. In the Data Editor, type 1 for Id and True for Perishable, then either press ENTER or TAB to shift focus away from the new row to commit it to the database.

5. Repeat the above step to enter 2, False and 3, False to the table.

   Notice that as you are editing a row, you can always revert the changes to a cell by pressing ESC.

6. You can view your edits as a script by clicking the Script button on the toolbar. Alternatively, you can use the Script to File button to save them in a .sql script file to be executed later.

7. Right-click the Trade database in SQL Server Object Explorer, and select New Query. In the editor, type select * from dbo.PerishableFruits and press the Execute Query button to return the data represented by the PerishableFruits view.