PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statement should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
DROPTABLE Orders

B.
DELETE FROM Orders

C.
TRUNCATETABLE Orders

D.
DELETE FROM OrderDetails


Leave a Reply