search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.59k stars 908 forks source link

Can't use Table design on 1 SQL database, but it works for another #25987

Open ABrodie12 opened 1 month ago

ABrodie12 commented 1 month ago

Steps to Reproduce:

  1. Not sure this is reproduceable in other environments since one database in our environment works with no issues, but another does not.
  2. Open up a SQL Database in Azure Data Studio.
  3. Click the drop down on tables to view tables.
  4. Click the pencil icon to the right of the table (Design)
  5. Make any changes and then publish.
  6. Get this error - Table schema validation failed with error: One or more errors occured during validation.1. The element data_1 is not supported in Microsoft Azure SQL Database v12.
  7. Tried this on another Azure SQL Database that is configured the same way and it published with no issues.

Does this issue occur when all extensions are disabled?: Yes