Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24468 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil
Delete Commands:
it is dml statement
you can specify delete command with critery (where
condition)
syntax: Delete * from tablename where condition
Truncate Command:
it is DDL statement
you can not specify critery with truncate table
syntax: truncate table tablename
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the use of toad or sqldbx.?
What is database isolation in sql server? : sql server database administration
Can you index views?
How to edit table in sql server 2017?
How can you tell if a database object is invalid?
What are sql azure firewall rules?
What are “lost updates”?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
how to trace the traffic hitting a sql server? : Sql server database administration
What are distributed partitioned views?
What is the filtered index?
What is a recursive stored procedure in sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is DCL?
How to get the query of a table in sql server?
