Welcome to Part 4 of our How to insert, update, or delete data in SQL Server course. Today, we will learn about using
DELETE operations that refer to other tables. Knowing how to use these structures will enhance your T-SQL skills.
First, let's familiarize ourselves with the database we will be working with. This is a database of an online store. There are four main tables:
Purchase. The store wants to add a reporting and archiving system. In this part, you'll be helping the staff to fill in new reporting and archiving tables.