what is the difference between delete,drop and truncate
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
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are the steps you should follow to start sql server in single-user mode?
What is table constraint?
Explain primary key and foreign key constraints?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
If a table does not have a unique index, can a cursor be opened on it?
Tell me what is log shipping?
Can we join two tables without primary key?
How do I run a trace in sql server?
Give an example of SQL injection attack ?
What are the differences between user defined functions and stored procedures?
How to remove duplicate rows from table except one?
How to find the version of sql server? : sql server database administration
how would you store your query in an SSRS report or a Database server?
How to include date and time values in sql statements?