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 procedure uses entities created in previous procedures in the Project-Oriented Offline Database Development sections.
To edit data in a table visually using the Data Editor
Right-click the Products table in SQL Server Object Explorer, and select View Data.
The Data Editor launches. Notice the rows we added to the table in previous procedures.
Right-click the Fruits table in SQL Server Object Explorer, and select View Data.
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.
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.
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.
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 thePerishableFruits
view.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for