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!
CodePudding user response:
Restore a backup to a different database or server and extract the view definition from there.