What is the difference between truncate and delete statement?
- 6 Answers
- 6619 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / ismail hasan
truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.
Delete statement will delete a particular row(s) on your
choice.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What happens if null values are involved in string operations?
What is the difference between getdate and sysdatetime?
How will you know when statistics on a table are obsolete?
Can you use order by when defining a view?
what is memory-optimized nonclustered indexes
Issues related in upgrading SQL Server 2000 to 2005 / 2008
 Explain what is sql override for a source taLle in a mapping?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How to create and drop temp table in sql server?
What is RAID? What are the different types of RAID configurations?
What is set nocount on?
Can the query output be sorted by multiple columns in ms sql server?
What will be the maximum number of index per table?
Can we check locks in database? If so, how can we do this lock check?
Explain about Normalization?
