Hi,

I'm sorry, I don't understand what you want to do exactly. Do you want
to copy a schema to a new name?

> Is there a way to add an additional column based on
> whether or not it is already there?

There are constructs such as "IF EXISTS" for some commands, but not
all of them. The complete grammar is documented at
http://h2database.com/html/grammar.html

H2 doesn't support a "SQL programming language" like T-SQL or PL/SQL.
If you do need such a feature, I suggest to use Java or another
programming language. H2 does support integrating Java functions /
stored procedures (see CREATE ALIAS).

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to