Re: DDL and transactions

From: Laconic2 <laconic2_at_comcast.net>
Date: Wed, 6 Oct 2004 07:00:49 -0400
Message-ID: <5qydnYUll_XrTf7cRVn-rA@comcast.com>

"Karel van der Walt" <karelvdwalt_at_webmail.co.za> wrote in message news:e743ac89.0410060205.27c28455_at_posting.google.com...
> Are DDL statements enclosed in transactions? I.e. is it ever possible
> to do a rollback on a DDL statement?

AFAIK, this is DBMS specific.

In DEC Rdb, CREATE, ALTER, and DELETE are all done in the context of a transaction for all schema objects, and for most database objects. You can DELETE TABLE EMPLOYEES, then do ROLLBACK or COMMIT. CREATE DATABASE, ALTER DATABASE, and DELETE DATABASE are done when no one is attached to the database, and no transaction is in progress.

Watch out for TRUNCATE, if it exists. In Oracle, at least, TRUNCATE is done outside the context of a transaction. Received on Wed Oct 06 2004 - 06:00:49 CDT