On 6/2/07, Jasbinder Singh Bali <jsbali@xxxxxxxxx> 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.