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
Explain about local stored procedure?
What is the return type of executeupdate ()?
What is filter index?
What is the contrast between sql and mysql?
How to download and install the scaled-down database adventureworkslt?
What is mean by candidate key?
What is inline table-value user-defined function?
Difference between primary key and clustered index?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Explain various On-Delete options in a DB table. Which is the default option?
Is truncate a dml command?
What are the different subsets of sql?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Explain the flow of creating a cube? : sql server analysis services, ssas
Explain temporary table vs table variable by using cursor alternative?