2

I need to confirm if a particular table ever existed on our SQL Server. Is there an existing script or method one can use to list all dropped databases in an SQL server?

Thom A
  • 88,727
  • 11
  • 45
  • 75
Brian Mogambi
  • 162
  • 1
  • 2
  • 13
  • 1
    There's an article discussing this here: https://blog.sqlauthority.com/2015/09/12/sql-server-who-dropped-table-or-database/ – Richard Hansell Aug 01 '18 at 14:29
  • Maybe this post is useful for you: [enter link description here](https://stackoverflow.com/questions/8829102/check-if-table-exists-without-using-select-from) – padro Aug 01 '18 at 14:30
  • This question is better suited for dba.stackexchange.com. DBAs handle such problems every day and know what works, what doesn't and how far back you can check. Devs have to google for this, unless they had to fix that problem at some point – Panagiotis Kanavos Aug 01 '18 at 14:31
  • Dropped tables or dropped databases? Anyway, you can pick up these events from the default trace, if they happened recently enough. See [this question](https://dba.stackexchange.com/q/48052/1186) for a start. – Aaron Bertrand Aug 01 '18 at 14:35

1 Answers1

0

There is a built-in report you can access through SSMS called Schema Changes History. You can run this to find what you're looking for.

user1443098
  • 6,487
  • 5
  • 38
  • 67