You have the two tables as shown in the following exhibit (Click the Exhibit button.).
The foreign key relationship between these tables has CASCADE DELETE enabled.
You need to remove all records from the Orders table.
Which Transact-SQL statement should you use?
A.
DROPTABLE Orders
B.
DELETE FROM Orders
C.
TRUNCATETABLE Orders
D.
DELETE FROM OrderDetails