Who Dropped Your Table? – SQL in Sixty Seconds #112


 

Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. A very valid question indeed as my client was working on a table which was suddenly disappeared from the database. After a while, it was more shocking to see that their entire database where we were working disappeared. Thankfully, it was all happening on the replica server which we had created for the testing and development.

Now the problem which was in front of us was very unique. The table and database were indeed deleted by someone from their team only and probably they