On 9/29/01 10:28 PM, "Gunnar R�nning" <[EMAIL PROTECTED]> wrote:
> * 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. I am not expecting that a single statement will work with all the databases. We will continue to have templates for each of the database vendors to account for all the irregularities: all I'm really interested in doing is getting rid of having to create shell scripts and batch files in order to create the databases. Even if the SQL was different for each of the databases, most of them are the same though, we can use the <sql> task to create the databases instead of native scripts. > Do you have access to SQL99 standard ? I'm sure I could dig it up if I had to :-) -- jvz. Jason van Zyl http://tambora.zenplex.org http://jakarta.apache.org/turbine http://jakarta.apache.org/velocity http://jakarta.apache.org/alexandria http://jakarta.apache.org/commons --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
