db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Meany <dan_me...@yahoo.com>
Subject Re: Unique constraints on multiple fields with one nullable
Date Thu, 27 Oct 2005 21:49:35 GMT
DB2, at least with the version/settings we have, seems
to be able to do a CREATE UNIQUE INDEX WHERE NOT NULL,
but not MS SQL Server.

Here's a further discussion of this topic...
http://weblogs.sqlteam.com/davidm/archive/2004/05/21/1364.aspx


Mime
View raw message