Pergunta de entrevista da empresa Amdocs
difference between DROP, TRUNCATE, DELETE which is fast and feasible.
Resposta da entrevista
Sigiloso
18 de ago. de 2016
DROP and TRUNCATE are ddl commands and cant be rolled back. DELETE is DML command and can be rolled back. TRUNCATE and DELETE are similar, the only difference is the former cant be rolled back. DROP deletes table data as well as its structure from database. DELETE and TRUNCATE only delete the table data.