dbschema
dbschema copied to clipboard
Changing PK's from Clustered to Non-Clustered Has No Effect
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.