Re: Transactional DDL

But its said that transactions in any RDBMS follow ACID properties.
So if i put a create table and an Insert statement in the same begin end
block as one single transactioin, won't both create and insert follow acid
property, being in one single trasaction, and either both get committed or
none, talking about oracle lets say

On 6/2/07, Alexander Staubo <alex(at)purefiction(dot)net> wrote:
>
> On 6/2/07, Jasbinder Singh Bali <jsbali(at)gmail(dot)com> wrote:
> [snip]
> > I believe that if a database supports transactional ddl then ddl1 and
> ddl2
> > would commit together as a batch
> > And
> > If a Db doesn't support this transactional DDL feature then ddl1
> executes
> > and commits without even caring about ddl2. Right?
>
> Exactly right -- Oracle, for example, implicitly commits the
> transaction when you execute a DDL statement such as "create table".
>
> Alexander.
>