A customer recently brought up an interesting thesis, that if you edit a table’s values using SQL Server Management Studio (SSMS) using the edit feature, that the table is dropped and recreated in the background when you commit the changes.
This is false, but there had to be a good reason why they were under this misapprehension.
Read on to understand what does happen and where the customer might have gotten this idea.