You have the following two tables.
The foreign key relationship between these tables has CASCADE DELETE enabled.
You need to remove all records from the Orders table.
Which TransactSQL
statement should you use?
A.
DROP TABLE Orders
B.
DELETE FROM Orders
C.
TRUNCATE TABLE Orders
D.
DELETE FROM OrderDetails