DELETE
DROP
TRUNCATE
commands ....?
major difference between DELETE DROP TRUNCATE
major difference between
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abdu RafeeqPosted Nov 10, 2013, 8:42 PM
1.To delete records from table(if set primary key in a table Id reference not deleted)
2.It have roll back
3.we can set conditions
Truncate
1. To delete records from table(if set primary key in a table Id reference deleted)
2.it have no roll back
3.we can't set conditions
Drop
1.To remove table from database