Create a "Case Sensitive" unique key

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create a "Case Sensitive" unique key

Author

Topic

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 2009-08-06 : 10:39:29

How do I create a "Case Sensitive" unique key constraint on a column

so that

sqlteam is different from SQLTEAM

If it is that easy, everybody will be doing it

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-06 : 10:43:27

Change COLLATION for the column to a CASE SENSITIVE collation.

N 56°04'39.26"
E 12°55'05.63"

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 2009-08-06 : 11:05:03

Hi Peso

Do you know the exact one, there are thousands there
http://msdn.microsoft.com/en-us/library/ms144250.aspx
I am based in the UK

If it is that easy, everybody will be doing it

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-06 : 11:35:13

Look for one similar to your current one but with a "_CS_" in there instead of "_CI_"

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources