'Recovering a deleted view in SQL Server
I have the following problem in my database in SQL Server.
I just right-clicked on a view and CREATE, looked at the script of the view and made a few adjustments. Then add and execute a DROP "View_xy" above the CREATE.
There was an error with the customizations, so the view was dropped, but the CREATE could not be executed. Because of all the fast fast I discarded my adjustments and closed the window.
Unfortunately, of course, the view is now deleted and the script is also gone.
Is there a way to restore the script of the view without resorting to the backup?
(I want to avoid backup, because this booth is eve and I made many changes in other views today)
Thank you in advance!
Solution 1:[1]
Restore a backup to a different database or server and extract the view definition from there.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | David Browne - Microsoft |