On 6/2/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match