Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete,drop and truncate
- 2 Answers
- 6761 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
How to change the system date and time from SQL Plus Terminal ?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What are the common performance issues in sql server?
Explain about Views?
How many types of subqueries are there in sql server?
Explain partitioned view?
What is the recursive stored procedure in sql server?
Determine when an index is appropriate?
What is the use of floor function in sql server?
When to use Inner join & when to use subquery?
What are the types of indexing?
Explain different types of index?
Where can you find the error log information? : sql server database administration
What is the difference between composite index and covering index?
What is the difference between nvl and nvl2?
