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 |
|
wombel
Starting Member
14 Posts |
 Posted - 2002-07-23 : 05:34:52
|
| Hi,as primary keys are created clustered by default I now have the problem the I need another index to be clusterd instead of the primary key. Now, how can I alter the primary key in a way, that it just looses the clustered property?TIAThomas WrobelSenior IT Manager |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-07-23 : 06:01:53
|
| If you go into Enterprise MAnager and do a design view of your table and choose properties then Indexes, you can uncheck the clustered box for that column. Add a new index and cluster that one. |
 |
|
|
wombel
Starting Member
14 Posts |
Posted - 2002-07-23 : 06:36:56
|
Thanks!quote:
If you go into Enterprise MAnager and do a design view of your table and choose properties then Indexes, you can uncheck the clustered box for that column. Add a new index and cluster that one.
Thomas WrobelSenior IT Manager |
|
|
|
|
|
|
Alter primary key