What is difference between delete and truncate in sql?
Anonymous
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
Check out your Company Bowl for anonymous work chats.