How to find a deleted view

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

How to find a deleted view

Postby dlbridgeman » Mon Jul 29, 2013 2:47 pm

I have found that a view which one of my applications depends on has been deleted by someone at some point. How do I find the revision where this happened? Is there a way that I'm not seeing to search history, aside from clicking on each revision?

Posts: 3
Joined: Mon Jul 29, 2013 2:43 pm

Postby james.billings » Wed Jul 31, 2013 3:13 pm

Within SSMS there's no easy way that I'm aware of.

It's probably a job better suited for the native tool you'd use with your source-control system. For instance, with TortoiseSVN I can right-click on the Views folder in my repository and see all the history of operations, then filter by filename:

Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests