DDL and transactions

From: Karel van der Walt <karelvdwalt_at_webmail.co.za>
Date: 6 Oct 2004 03:05:44 -0700
Message-ID: <e743ac89.0410060205.27c28455@posting.google.com>

Are DDL statements enclosed in transactions? I.e. is it ever possible to do a rollback on a DDL statement?

I have mostly seen big schema generation scripts interrogate the catalog before firing DDL rather than fire DDL catch SQLERROR and do rollbacks.

Does it depend on wether the DBMS does optimistic (multiversion) concurrency control like Interbase, Oracle) or pessimistic concurrency (WAL) control (like Sybase, MS SQL Server) ?

Karel Received on Wed Oct 06 2004 - 05:05:44 CDT