Re: DDL statements and transactions
From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 07 Sep 2002 23:38:53 GMT
Message-ID: <Xns9282A95B62079SunnySD_at_68.6.19.6>
Date: Sat, 07 Sep 2002 23:38:53 GMT
Message-ID: <Xns9282A95B62079SunnySD_at_68.6.19.6>
vk02720_at_my-deja.com (vk02720) wrote in
news:4d814faa.0209071120.769db626_at_posting.google.com:
> Are DDL statements like create table and delete or truncate part of
> the transaction ?
> I mean if you DELETE a table can you recover using ROLLBACK ?
>
> TIA
One does NOT "DELETE a table".
The correct command is
DROP TABLE FUBAR;
FWIW - All DDL statements issue an implicit COMMIT.
Therefore ROLLBACK is NOT possible with any DDL statement.
HTH & YMMV HAND! Received on Sun Sep 08 2002 - 01:38:53 CEST