Difference between Delete, Drop & Truncate in SQL Server
Delete :
1) you can delete all rows from the table or
based on some condition (Where clause) rows data we can delete
2) we can roll back data if we use to delete
3) actual table will not delete from the database only we
can't delete data
Truncate :
1) you can't use where condition by using truncate
2) we can't rollback (we can't get data )
if we use truncate
3) actual table will not delete from the database only we
can't delete data
DROP :
1) you can't use where condition by using Drop
2) we can't rollback (we can't get data )
if we use DROP
3) actual table delete from the database
delete from carmaster where id =4
truncate table carmaster
drop table carmaster
On this page of the site you can watch the video online Difference between Delete, Drop & Truncate in SQL Server with a duration of hours minute second in good quality, which was uploaded by the user DotnetMaster 10 May 2022, share the link with friends and acquaintances, this video has already been watched 31 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
