Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18986 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
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How to start and end transact-sql statements?
what are the disadvantages of cursors? : Sql server database administration
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to create “dependant” parameter “make, model, year”
Do you know what is xpath?
How to change the system date and time from SQL Plus Terminal ?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is check constraint in sql server?
What is a transactions?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What kind of problems occurs if we do not implement proper locking strategy?
What are system databases in ms sql server?
What is wrong with sql server client libarary dll, ntwdblib.dll?
what is a live lock? : Sql server database administration
