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
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How many types of attribute relationships are there? : sql server analysis services, ssas
What are the different authentication modes in sql server? How can it be changed?
We need to perform what steps in the following order to work with a cursor?
What is PROJECTION Operation?
What is bookmark link in ssrs?
What are the filtered indexes?
How can we determine what objects a user-defined function depends upon?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the differences between char and nchar in ms sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Why can there be only one clustered index and not more than one?