dbschema icon indicating copy to clipboard operation
dbschema copied to clipboard

Changing PK's from Clustered to Non-Clustered Has No Effect

Open NeilN1 opened this issue 11 months ago • 0 comments

DbSchema 9.5.2. SQL Server 2016.

Changing a PK from clustered to non-clustered will not send any table modification statements to the database. Furthermore, a subsequent "Refresh from Database" will not pick up the difference between the table and the model. I understand why table modification statements might not be generated as they can be complex, with FK's having to be dropped and re-created, but the difference should be detected.

image

NeilN1 avatar Mar 21 '24 00:03 NeilN1