Delete command is used to delete data from a table for example Remove emails where we write a script to delete the customerâ€™s data. It deletes the rows of data from a table. The syntax of it as follows:
DELETE FROM table_name
Whereas, truncate is very dangerous command and should be used carefully as it deletes every row from a table. The syntax of it as follows:
TRUNCATE TABLE "table_name"