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.
| Author |
Topic |
|
tincupal
Starting Member
24 Posts |
 Posted - 2007-10-18 : 17:37:43
|
| SQL 2000 Enterprise Manager won’t let me drop a unique key index and move it to another field. I get an error regarding ‘drop index not allowed because of unique key constraint enforcement.Is there anyway to change fields for unique keys in SQL Enterprise Manager?Thanks, Al |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-10-18 : 19:57:17
|
| what are you trying to do? Chakge PK from field1 to field2?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tincupal
Starting Member
24 Posts |
Posted - 2007-10-19 : 09:09:02
|
| yes, I'm trying to change the primary key from field1 to field2. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
tincupal
Starting Member
24 Posts |
Posted - 2007-10-19 : 13:23:16
|
| YES, thanks very much. Boy, am I glad I found this site. |
|
|
|
|
|
|
Changing Field for Unique Key Index