T-SQL Data Manipulation

DELETE vs DROP vs TRUNCATE

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This segment explains how to remove large amounts of data fast by dropping and truncating entire tables. You’ll learn the difference between deleting, dropping, and truncating so that you can make the correct choice in a given situation.

Keywords

  • SQL Server
  • T-SQL
  • Delete
  • Drop
  • Truncate

About this video

Author(s)
John Deardurff
First online
10 May 2019
DOI
https://doi.org/10.1007/978-1-4842-4993-2_8
Online ISBN
978-1-4842-4993-2
Publisher
Apress
Copyright information
© John Deardurff 2019