> >>2. Constraints?
> >
> > Constraint:
> > ALTER TABLE "I_TABLE_ÅÄÖ" ADD PRIMARY KEY
> > ("ÅÄÖID");
>
> Ah, but how about this:
> ALTER TABLE "I_TABLE_ÅÄÖ" ADD PRIMARY KEY "ÅÄÖ_PK" ("ÅÄÖID")

As far as I can see, that isn't valid DDL :-)

This works though:
ALTER TABLE "I_TABLE_ÅÄÖ" ADD CONSTRAINT "ÅÄÖ_PK" PRIMARY KEY
("ÅÄÖID");

> >>3. Lower-case/mixed-case (in all places)?
> >
> > What do you mean by this?
>
> I meant, does it work even if I want to name my
> table/field/index/constraint "MinLåda" (= "MyBox" in English)? I think I
> had problems only with lower-case åäö in one of the tools I tested.
> Hence the question.
>
> > Anyway, if you're using mixed case, Database Workbench will

automatically

> > quote the identifiers in the editors or generated SQL statements.
>
> Sounds good, as usual. :-) When we start making money we might just
> inves in your tool as well as your FB driver, although we'd like to stay
> on ADO since we also use MSSQL.

Oh, did I mention anything 'bout the cross-database capabilities of
Database Workbench yet :-)


I just migrated SCOTT (Oracle) to Firebird in under 1 minute. *g*

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com