What is the difference between DELETE and TRUNCATE?
Answers were Sorted based on User's Feedback
Answer / shilpa
Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / debi
1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate
Is This Answer Correct ? | 2 Yes | 2 No |
Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.
ramumcato@yahoo.com
Is This Answer Correct ? | 9 Yes | 11 No |
Answer / sanjay keserwani
we can go upto some number of records through delete while
in truncate we have to unoccupied all records.
Is This Answer Correct ? | 4 Yes | 7 No |
Answer / amol
Be very careful when deleting records. You cannot undo this
statement! but in mysql...
Is This Answer Correct ? | 0 Yes | 5 No |
How can u find column name from a table which have max value in a row.( not max value)
what are all different types of collation sensitivity? : Sql dba
What is difference between sql function and stored procedure?
Can we change the table name in sql?
Why is sql important?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
What problem one might face while writing log information to a data-base table in pl/sql?
how to present a past time in hours, minutes and seconds? : Sql dba
Does a join table need a primary key?
What is clustered index sql?
What is a procedure in pl sql?
Can we insert data in view?