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

Recursive Queries in MS SQL Server

Introduction
CTEs with data modifying statements
11. DELETE statement
Summary

Instruction

Great! It's time for the last data modification statement, DELETE. First, we will review its syntax. This statement is used to remove records from a table. Look at the example:

DELETE FROM Customer
WHERE Id = 15;

This statement starts with a DELETE FROM, after which we give the name of the table. In this case, we delete records from the Customer table. In the WHERE clause, we specify which records to delete. In this query, the condition Id = 15 causes the removal of only one record, the one with an ID equal to 15.

Exercise

Remove the store with the Name of Small Grocery Store from the database.

Stuck? Here's a hint!

Use DELETE FROM ... WHERE ....