如何将主聚集索引更改为非聚集索引。(作为“次要”表,我想将聚集索引用于“头”表的外键列。)
这对我不起作用(错误似乎是合理的 :)
DROP INDEX ClientUsers.PK_ClientUsers
CREATE UNIQUE CLUSTERED INDEX IDX_ClientUsers_Id ON ClientUsers(Id)
Msg 3723, Level 16, State 4, Line 7
An explicit DROP INDEX is not allowed on index 'ClientUsers.PK_ClientUsers'.
It is being used for PRIMARY KEY constraint enforcement.