What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
Answer Posted / radh
TRUNCATE is a DDL command whereas DELETE is a DML command.
Hence DELETE operation can be rolled back, but TRUNCATE
operation cannot be rolled back. WHERE clause can be used
with DELETE and not with TRUNCATE.
Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
Why it is recommended to avoid referencing a floating point column in the where clause?
How to get a list of columns in a view using the "sp_help" stored procedure?
Can a unique index be created on a column, which contains null?
Write a SQL query to make a column as unique?
How to change the system date and time from SQL Plus Terminal ?
How to set the current database in ms sql server?
What are the diifferences between the ms sql server vs mysql?
Explain the use of containers in ssis?
What is query parameter in ssrs?
What are translations and its use? : sql server analysis services, ssas
What does it mean to invest in the index?
What is difference between unique and primary key?
What is the difference between value type and reference type?
What is page in sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration