Find the user who dropped database table

First, let us drop the table by following command.

DROP TABLE TempTable
GO

Now the challenge is how to find out who dropped the table which was created in the database.

There is a simpler way to do the same.

Right click on the database then Go to Reports -> Standard Reports -> Schema Changes History.

Once you open Schema Changes History, you will see a report. Over there, expand any object which you are interested in and you will see necessary details associated with the same.

For ex., I am interested in TempTable and you can see it shows the three rows of schema change. You can also see the name of the user and time when he/she dropped the table.