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
На этой странице сайта вы можете посмотреть видео онлайн Difference between Delete, Drop & Truncate in SQL Server длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь DotnetMaster 10 Май 2022, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 31 раз и оно понравилось 1 зрителям. Приятного просмотра!
