hi guys
in this post i will talk about the difference between delete statements in SQL
lets go
Drop statement :
drop is Data Definition Language Statement used in Level of database objects such as table
and to drop table this mean you will delete structure and data in table
So drop used to delete structure and data
But delete and truncate used to delete data only without structure but difference is
Delete Statement :
delete data only and log it in ldf this mean you can rollback and undo after execute delete statementbut it is overhead and affect performance because you need log before delete
No comments:
Post a Comment