Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19038 Views
- I also Faced
- E-Mail Answers
Answer Posted / baijnath tiwari
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 ? | 1 Yes | 2 No |
Post New Answer View All Answers
What does <> symbol mean?
How to edit table in sql server 2017?
What are the differences between sql server and mysql.
Explain Capacity planning to create a database? and how to monitor it?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What are different types of join?
Define constraints and give an example of their use?
What is the difference between lock, block and deadlock? : sql server database administration
How to update multiple rows with one update statement in ms sql server?
Explain about analysis services?
How do you improve the performance of a SQL Azure Database?
How to download and install microsoft .net framework version 2.0?
Can sub report data source be different from that of the parent report?
What is the downside of using udf?
What is a result set object returned by mssql_query()?
