db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Unique Column with null values
Date Thu, 10 Nov 2011 02:11:34 GMT
> is there a way to mix an unique column with null values. So that i have an column where
only unique values are allowed with the
> exception of multiple null values.

Yes.

Since Derby 10.4, that is the way that Derby's table-level UNIQUE constraints
have worked. See:

http://db.apache.org/derby/docs/10.8/ref/rrefsqlj13590.html

thanks,

bryan


Mime
View raw message