Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8865 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 is a transaction and what are acid properties? : Sql server database administration
What is policy based management (pbm)? : sql server database administration
Tell me what is a linked server?
What is relationship? What number of sorts of relationship are there?
Is BCNF better than 2NF & 3NF? Why?
Which language rdl files made of?
What is openrowset sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What do you understand by hotfixes and patches in sql server?
What is key set driven?
Are connections to sql server encrypted?
What is a fill factor?
What is the need for indexing?
Difference between primary key and clustered index?
What you can do to delete a table without the delete trigger firing?
