What is difference between delete and truncate in sql?
Sigiloso
Answer delete is used to delete a specific row we can use where clause and is a type of dml whereas truncate is used when we need to completely delete all rows in table and is type of ddl