PrepAway - Latest Free Exam Questions & Answers

Which TransactSQL statement should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
DROP TABLE Orders

B.
DELETE FROM Orders

C.
TRUNCATE TABLE Orders

D.
DELETE FROM OrderDetails


Leave a Reply