Delete statement in SQL
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
Truncate statement in SQL
//or you can write
delete from tbTeacher where teacherId = 1
- Truncate statement will delete all data from Table
- Truncate statement reset the identity column value with seed value
- Truncate statement cannot be written with where clause
- if you have any FOREIGN KEY Referenced, then it will not allow to truncate the table and throw error "Cannot truncate table 'tableName' because it is being referenced by a FOREIGN KEY constraint".
Let's take a look at the SQL Truncate example
Truncate table tbTeacher
// you cannot write
Truncate table tbTeacher where teacherId = 1