Yes it would. But it's missing for any user-defined type. What I want to know, is if there's something I need change in SQL Server 2005 to let this happen, or some method on an object I need to implement or if it's just not possible.
Thanks, Mike On 12/14/05, Vince P <[EMAIL PROTECTED]> wrote: > > Wouldn't that be a table-level property on the column for which you are > assigning the type? > > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Andrews > Sent: Wednesday, December 14, 2005 3:37 PM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] SQL Server 2005 User-Defined Data Types (CLR) > and > constraints... > > Guys, > > Do any of you know if you can put a constraint on a CLR data type? > > What I've been doing is some experimentation with SQL Server 2005 and I've > created as user-defined data type. What I'd like to know is if I can have > a > unique constraint on that data type to prevent duplicates. > > Thanks, > Mike > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
