what is the difference between delete,drop and truncate
- 2 Answers
- 5810 Views
- Honeywell, Zomato, I also Faced
- E-Mail Answers
Answer Posted / krishna
DELETE,DROP,TRUNCTATE are to use the remove the rows from the table
DELETE: Delete is used to delete the rows from table by using where condition also and we can ROLLBACK it also
DROP: Delete rows permanently and we can not ROLLBACK it.
TRUNCATE : Delete the data not the structure means in this delete only data but structure is same
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the information that can be stored inside a bit column? : Sql server database administration
Can you explain what is indexed view? How to create it?
What happens if date-only values are provided as date and time literals?
What are triggers in ms sql server?
What is an inner join?
Write query to return all rows sql?
How to change the password of a login name in ms sql server?
What is the web service used for reporting services?
What are unicode character string data types in ms sql server?
How to start and end transact-sql statements?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Describe in brief sql server monitoring ways.
What are the three different part of rdl file explain them?
What is transaction server consistency?
What is postgresql server?
