add option to view commited deleted object code from repsostiry in SSMS
Currently there is not easy way to see or restore a deleted object that was committed. The object code is still in Source Control - but no easy way to see or restore it using SSMS.
I believe that this is achievable by viewing object history in SQL Source Control and then launching SQL Compare or SQL Data Compare to do a diff and potentially restore the prior version. More info is here: https://documentation.red-gate.com/soc7/common-tasks/update-to-a-revision-from-source-control
This does require having licenses for SQL Compare and SQL Data Compare, however, and your suggestion is specific to doing this with SSMS, so I am not marking this as complete.
Implement a seach function will be very helpfull to find those deleted/dropped objects. Search the history by hand is not very efficient.
Michael Murphy-McCarthy commented
Kendra, that only works if you can find it. Finding a deleted/dropped object requires manually going through the history. There is no way to search for a deleted object.