what is the difference between delete,drop and truncate
Answer Posted / mohammadali.info
*The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to
COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
*TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
*The DROP command removes a table from the database. All the tables' rows,
indexes and privileges will also be removed. The operation cannot be rolled back.
*DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
IF Answer is Correct Pls give Rate
Is This Answer Correct ? | 46 Yes | 0 No |
Post New Answer View All Answers
What is the difference between ddl,dml and dcl commands?
Can you use order by when defining a view?
What stored by the model?
Does hive support indexing?
How do you delete a data source?
What is a full text index?
what is the difference between a primary key and a unique key? : Sql server database administration
What number sorts of privileges are accessible in sql?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Explain how many types of relationship?
What are the steps to insert a table?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
what are constraints? : Sql server database administration
What is the architecture of ms sql reporting service?
What is the difference between deallocate cursor and close cursor?