Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Insert, Update, or Delete Data in MS SQL Server

Introduction
Inserting data
Modifying data
Deleting data
CRUD
17. Exercise 3—delete

Instruction

Nice! Now, we need to make one final change in the menu. Give it a go.

Exercise

Oysters Bienville (ID 1) aren't really popular. Let's remove them from the menu.

Stuck? Here's a hint!

Type:

DELETE FROM Dish 
WHERE Id = 1;