Re: Database and Views

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Fri, 25 May 2001 21:37:19 +0200
Message-ID: <9emc9f$5a0$03$3@news.t-online.com>

manav wrote:

> A dept manager called and reported that some of the views that were
> created last wednesday on the DEV database(ON DVELOPMENT SERVER) WERE
> MISSING.
> The DEV databse was actually refreshed on sunday (from production
> databse).
> Now my Questions are:
>
> What should I do if only one view was missing?
> If multiple views were missing what should be done?

Don't you have the SQL that created the views? If you do, just run them again. Losing views does not imply using data.

Joachim Received on Fri May 25 2001 - 14:37:19 CDT