You created the two tables below. Later, you decide that you want the database to remove all books from the Books table if the related publisher is deleted from the Publishers table. What command should you run?
CREATE TABLE Books (
BookID int PRIMARY KEY,
BookTitle nvarchar(100) NOT NULL,
PublisherID int NOT NULL
);
CREATE TABLE Publishers (
PublisherID int PRIMARY KEY,
PublisherName nvarchar(50)
);