Hi again,

Another question related to dialects' implementation. I have a very limited implementation of HSQLDB in C# which does not implement ALTER TABLE ADD CONSTRAINT unfortunately.

Is there a way to controll FOREIGN KEY constraint strategy? I would like to replace existing way (via ALTER TABLE) with adding constraint at the table time.

Also, the question is whether it makes sense (the lack of ADD CONSTRAINT syntax leads to lack of schema update possibility). I have a possibility of implementation supplementation (I am working with the code taken from gotDotNet).

I've investigated it a little and it looks like there is the only way of table creation (among whith the constraints) - creating a table first and then altering it with adding constraints.

Maybe this is the best way from the point of view of DB engine variety - please let somebody explain it to me...

What was the exact reason of doing it this way and closing the alternative paths? Maybe it could be easily extended - I can do this, possibly...

You can try looking at HSQLDialect in Hibernate and port it over to .NET.