Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18695 Views
- I also Faced
- E-Mail Answers
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
What is an entity-relationship diagram (erd)?
Why do we use functions?
Does windows server 2016 come with sql server?
Mention the 3 ways to get a count of the number of records in a table.
What is encryption key?
what are the three command line utilities and what are their primary functions?
how many clustered indexes can be created on a table? : Sql server database administration
Tell me what is the order in which the sql query is executed?
How to verify a login name with sqlcmd tool?
How do you make a trace?
What are ddl triggers and types of ddl trigger?
How to locate and take substrings with charindex() and substring() functions?
Can sub report data source be different from that of the parent report?
Which language is supported by sql server?
What is difference between join and natural join?
