Export (0) Print
Expand All

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 Caution:
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.

© 2015 Microsoft