Home > Net >  Recovering a deleted view in SQL Server
Recovering a deleted view in SQL Server

Time:03-18

‎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.

  • Related