[Last Call] Learn how to a build a cloud-first strategyRegister Now


Recover deleted sql View

Posted on 2005-04-18
Medium Priority
Last Modified: 2012-06-27
I deleted a view thinking that, I won't need it anymore. But I want it again. Is there a way I can recover that deleted view?


Question by:AnuPutcha
LVL 17

Accepted Solution

mokule earned 750 total points
ID: 13811150
If You have any backup of this database with this view You can restore it to some new database nad then generate sql script for desired view

Author Comment

ID: 13811539
Thanks for the suggestion, I will check with my database admin to see if they have a backup .


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question