Re: [GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread Rakesh Kumar
> Just what I was thinking. Are you looking in the correct database? All: He has already replied to me earlier that he had indeed dropped the schema before creating it.

Re: [GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread Alban Hertroys
> On 28 Nov 2017, at 16:43, David G. Johnston > wrote: > > On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR > 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"

Re: [GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread David G. Johnston
On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR < venkteshgutte...@gmail.com> 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

Re: [GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread Melvin Davidson
On Tue, Nov 28, 2017 at 7:23 AM, VENKTESH GUTTEDAR < venkteshgutte...@gmail.com> wrote: > Hello All, > > > I have run CREATE SCHEMA xyz accidentally, and it replaced my existing > schema (xyz) with tables, and i have lost all my data. > > Is there any way to rollback or get the schema back

[GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread VENKTESH GUTTEDAR
Hello All, I have run CREATE SCHEMA xyz accidentally, and it replaced my existing schema (xyz) with tables, and i have lost all my data. Is there any way to rollback or get the schema back with old tables and data. Any help would be appreciated. -- Regards : Venktesh Guttedar.