डिफरेंस बिटवीन डिलीट एंड सी एलएस कमांड
Answers
Answered by
3
Answer:
Difference between DELETE and TRUNCATE
1. DELETE :
DELETE is a DML(Data Manipulation Language) command and is used when we specify the row(tuple) that we want to remove or delete from the table or relation. The DELETE command can contain a WHERE clause. If WHERE clause is used with DELETE command then it remove or delete only those rows(tuple) that satisfy the condition otherwise by default it removes all the tuples(rows) from the table.
Similar questions