SQL perguntas e respostas de entrevista
Question: What is the difference between TRUNCATE and DELETE commands?Answer: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.DELETE is a DML command and can be rolled back. Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster. |
Salvar para revisao
Adicione este item aos favoritos, marque-o como dificil ou coloque-o em um conjunto de revisao.
Faca login para salvar favoritos, perguntas dificeis e conjuntos de revisao.
Isto e util? Sim Nao
Mais uteis segundo os usuarios: