You have a database that contains two tables named Table1 and Table1_Details.
Table1_Details contains details about items in Table1. You need to ensure that when an
item is removed from Table1, all related items are removed from Table1_Details. You must
achieve this goal by using the minimum amount of Transact-SQL code. What should you
do?
A.
Create a foreign key relationship. Set Cascade Delete to Null.
B.
Create a foreign key relationship. Set Cascade Delete to True.
C.
Create a trigger on Table1_Details that fires on the Delete action.
D.
Create a stored procedure that deletes all related items from Table1_Details.