SQLServerCentral / SQL Server 7,2000 / Strategies / Alter constraints - non-clustered PK -> Clustered PK / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:13:46 GMT20RE: Alter constraints - non-clustered PK -> Clustered PKhttp://www.sqlservercentral.com/Forums/Topic963766-49-1.aspxThanks Jack,That's what I was afraid of. Ah well, it needs doing, so....PThu, 05 Aug 2010 05:47:27 GMTschleepRE: Alter constraints - non-clustered PK -> Clustered PKhttp://www.sqlservercentral.com/Forums/Topic963766-49-1.aspxDon't think you can do it without dropping all the FK's and then dropping and recreating the PK and then re-adding the FK'sWed, 04 Aug 2010 20:47:04 GMT Jack CorbettAlter constraints - non-clustered PK -> Clustered PKhttp://www.sqlservercentral.com/Forums/Topic963766-49-1.aspxHi all, In SQL 2K (or SQL 2K8), is it possible to programmatically alter the PK constraints on the tables from nonclustered to clustered? When they're referenced by FKs?Or do I have to climb all the way down the referential tree, and drop and re-create the PKs from the bottom up?We're upgrading to SQL 2K8, and the lack of clustered indexes is becoming apparent.Thanks!PWed, 04 Aug 2010 13:03:04 GMTschleep