* Jason van Zyl <[EMAIL PROTECTED]> wrote: | | It would be nice if we could get rid of the script generation and just use | standard SQL to create the databases. Here's the information collected so | far. Looks like the 'CREATE DATABASE' might be standard. I haven't looked it | up.
I don't find any "create database" statement in the SQL-99 standard. It does however have "create schema". "create database" is really a misnomer for "create schema". The SQL standard talks about catalogs and schemas, but not about databases. A catalog can contain a set of schemas, while a schema contains table definitions. create database is inherently non-portable as you usually need to supply different configuration options for the different DBMSes. Do you have access to SQL99 standard ? -- Gunnar R�nning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
