SQL delete and truncate statement does almost same job, delete records from sql table, in this tutorial, you will learn how to write SQL delete statement and SQL truncate statement
Here we learn the difference between Delete and Truncate in SQL, When to use delete statement and when to use truncate, and what would be the impact on sql database.
// delete all the data delete from tbTeacher // delete all the data and reset index truncate table tableName
Delete statement will delete data from Table, delete statement can be written with where clause.
Let's take a look at the SQL Delete example
delete from tbTeacher //or you can write delete from tbTeacher where teacherId = 1 // Write some insert statement insert into tbTeacher (FullName, Address, Contactnumber, Updatedon) Values ('Some Name','Some Address', '9000000', getdate()) // Select * from tbTeacher
Notice in above screenshot: every time you execute a delete statement on a table and then keep inserting new records again and again, the index value will be automatically incremented for new records
Let's take a look at the SQL Truncate example, notice you cannot write where clause with truncate query.
Truncate table tbTeacher //you cannot write where clause with Truncate Truncate table tbTeacher where teacherId = 1
Notice in above screenshot: every time you execute a truncate statement on a table and then keep inserting new records again and again, the index value will NOT be incremented for new records, it will always starts from one.
NOTE: Like Delete Statement you can NOT use WHERE clause with Truncate statement.