i'm trying to accomplish the following task:
begin transaction;
begin work;
create table xyz(
id int
);
commit work;
select * from xyz;
rollback transaction;
select * from xyz; // should say database object doesn't exist
however i'm failing to be able to do this?? is there a specific reason?
I know in MSSQL you can say:
begin transaction
begin transaction test
create table xyz(
id [int]
);
select * from xyz
commit transaction test
rollback transaction
select * from xyz // database object doesn't exist
Is there an equivalent?
TIA