Re: - Regarding Schema ROLLBACK

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <venkteshguttedar@xxxxxxxxx> wrote:

    I have run CREATE SCHEMA xyz accidentally, and it replaced my existing schema (xyz) with tables, and i have lost all my data.

​As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it successfully execute if a schema of the same name already exist...

As Melvin says if you've truly dropped the data you will need to resort to backups of some form.​

David J.