Answer Posted / rajesh
Delete is DML statement which can delete data from table
which needs to be commited afterwards. But it doesn't free
memory area occupied by the data in the table.Where clause
can be used.
Truncate is DDL statement which is auto commit. It not only
deletes all data from table, but it also frees the memory
area occupied the data in the table. where clause is not
permitted. Works faster than delete statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is cte sql?
Are sql database names case sensitive?
What's the difference between a primary key and a clustered index?
What is the difference between alter trigger and drop trigger statements?
What do you mean by dbms? What are its different types?
How do I find duplicates in two columns?
What is left join in postgresql?
Is sql port 1433 encrypted?
Write an sql query to select all records from the table?
What is rtm in testing?
What is sql indexing?
What does select count (*) mean in sql?
What is sqlcommand?
What is a recursive stored procedure?
define join and explain different type of joins? : Sql dba
