A database contains two tables named Table1 and Table1_Details. Table1_Details contains
details about the 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 Cascade.
B.
Create a trigger on Table1_Details that fires on the Delete action.
C.
Create a stored procedure that deletes all related items from Table1_Detai!s.
D.
Create a foreign key relationship. Set Cascade Delete to Set Null.