What is Difference Between delete and Truncate?

Answer Posted / chandrakala

also delete is a DML statement where as truncate is a DDL
statement.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a pl/sql block?

586


How many types of keys are there in sql?

549


What are the types of records?

524


What is clause in sql?

575


Can a trigger call a stored procedure?

530






Explain what is sql?

599


How is pl sql different from sql?

536


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

613


How do you modify a table in sql?

557


Enlist some predefined exceptions?

575


how can we optimize or increase the speed of a mysql select query? : Sql dba

501


What is the cause of mutating table error and how can we solve it?

593


Does pl sql work in mysql?

526


Explain sql data types?

618


What company owns postgresql?

554