In SQL server difference between truncate and delete statements

Truncate releases the memory space allocated for the table and it can't be rolled back ie no logs are created for this command.

Delete only delete the records and this command can be rolled back ie log is created for this command.

No comments:

Post a Comment