what is the difference between delete and truncate?
Answers were Sorted based on User's Feedback
Answer / kadambari
Difference between Delete and Truncate :-
1. Truncate is a DDL statement hence it implicitly commits;
Delete is a DML statement hence we have to manually perform
commit.
2. Truncate doesn't fire the delete trigger hence it is
faster than Delete operation.
3. Once Truncated, data cannot be roll-backed; Delete
operation can be roll-backed.
4. Truncate resets the High water mark and frees up all the
extents; Delete doesn't reset the High water mark.
Thanks
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / nithya
The basic difference between delete and truncate is 'high
water mark'. High water mark indicates the max level to
which the data has risen in the table.
Deleting a table removes only the data from it whereas
Truncating a table removes all the data from the table and
resets the relevant pointers including 'high water mark'.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / venkatesh kumar.s
Truncate:The truncate command deletes the rows in the
table,but not the structure of the table.
Cmd-truncate table tablename;
Drop:The drop command will drop the table from the databases.
Cmd-drop table tablename;
Delete:The delete cmd removes tuples from a relation.It
includes where clause to select the tuples to be deleted.
Cmd-delete from tablenmae where attribute-name="value" or value;
Is This Answer Correct ? | 3 Yes | 0 No |
Truncate is more faster than delete.
in sql you need to write statement: truncate table
table_name
truncate delete all record from table.it remain only
structure of table.
Is This Answer Correct ? | 1 Yes | 7 No |
what is the difference between two and three-tier architectures?
Is mysql a rdbms?
Enlist the disadvantages of query.
What is index hunting?
What is rdbms and its types?
What are the types of distributed database?
Which database is used by google?
What is ddl in dbms?
Describe two phases of Two-phase commit ?
What do you understand by functional dependency and transitive dependency in dbms?
What is netlib for clipper?
Is it possible to Enable or Disable a Database trigger ?