diffrence between delete, turncate,drop in sql

diffrence between delete, turncate,drop in sql

Rajat Anand
Views: 235 | Community Opinion: 4



Bookmark this page..



Ask a New Question Go to Home

Community Opinion/Answers
 
Rajat Anand Said..

delete use to delete row
turncate use to delete row but we can use the deleted space but in drop we use to delete table structure which can't be longer use .




nagaraju kannuri Said..

1. You can't rollback data in TRUNCATE but DELETE you can rollback data.

2. TRUNCATE removes the records permanently.

3. TRUNCATE is faster than DELETE.




SURENDRA Said..

TURNCATE: This command removes the data permentaly from the table,and the structure of the table remains as it is.
it cannot flash back
DROP: It removes both Structure and yhe data tfrom the table Permentaly
it can flash back
DELETE "it can delete one or more rows from the table




Ankit Yadav Said..

In TRUNCATE : Removes data completely from table and data will can't rollback and identity column is start again from starting.
In DELETE: Removes data completely from table and data will rollback and identity column will continue from where we delete and also use the where command to delete a single row.
IN DROP:It removes both Structure and data the from the table Permentaly






What do you think? Add your opinion/answer
*Name
*your opinion/answer: