Sometimes you may need to do several ddl statements in a database.Suppose in a file you have list of DDL creation script. Now after creating some objects some DDL commands fails and it proceed further. As DDL tasks can't be rolled back so it may be cumbersome and difficult to identify/track which DDL command is actually failed. There is a command CREATE SCHEMA by which it can be ensured that either entire statement will successfully executed or entire statement will fail.

The details are discussed on http://arjudba.blogspot.com/2008/04/creating-multiple-tables-and-views-in.html

http://arjudba.blogspot.com