I have a primary key defined as a non-clustered index and is used to enforce FK references. When trying to flip the non-clustered to clustered in EM I get the message "Cannot convert a clustered index to a nonclustered index using the DROP_EXISTING option". When I try to delete the index I get the message "An explicit DROP INDEX is not allowed <tablename><constraint>. It is being used for PRIMARY KEY constratint enforcement". Any idea how I can get around this without having to drop all FK references.