How to drop clustered property but retain primary key in a table. SQL Server 2005

user_447221 0
Viewed 12488

i have the following key:

ALTER TABLE dbo.Table ADD  CONSTRAINT PK_ID PRIMARY KEY CLUSTERED 
(
ID ASC
)

so i have clustered index and primary key on ID column. Now i need to drop clustered index (i want to create new clustered index on another column), but retain primary key. Is it possible?

clustered-index primary-key sql-server-2005 sql-server sql
2 Answers
Related