Which statement is used to delete all rows in a table without having the action logged?

Options
- Drop table statement
- Delete table statement
- Truncate table statement

CORRECT ANSWER : Truncate table statement

Discussion Board
TRUNCATE TABLE

TRUNCATE TABLE removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.

Prajakta Pandit 03-7-2017 04:19 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲