Home > OS >  Prevent saving changes that require table re-creation in SQL
Prevent saving changes that require table re-creation in SQL

Time:10-14

I have a problem working in Azure Data Studio. In SQL Server Management Studio my problem can be fixed with a change to Tools >> Options >> Designers >> Table and Database Designers >> Uncheck – Prevent saving changes that require table re-creation. But I can't find any similar in Azure Data Studio. I can only use Azure Data Studio and docker because of my mac.

Can anyone help me with this setting in Azure Data Studio? Or is there a way I can adjust the indentity specification for a table that already has data?

CodePudding user response:

Prevent saving changes that require table re-creation Option comes under Table design.

Currently, this feature is not available in Azure Data Studio.

enter image description here

Use SQL Server Management Studio for this feature.

You can go through this MS document to learn more on when to use Azure Data Studio and when to use SQL Server Management Studio for different features.

  • Related