Which Transact-SQL 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 Transact-SQL statement should you use?

Exhibit:

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 Transact-SQL statement should you use?

A.
DROP TABLE Orders

B.
DELETE FROM Orders

C.
TRUNCATE TABLE Orders

D.
DELETE FROM OrderDetails



Leave a Reply 0

Your email address will not be published. Required fields are marked *