Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
NeilN1 opened this issue Mar 21, 2024 · 0 comments
Open

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

NeilN1 opened this issue Mar 21, 2024 · 0 comments

Comments

@NeilN1
Copy link

NeilN1 commented Mar 21, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant