Disclaimer: This article may contain information about third-party products. Such information is for reference only. Alibaba Cloud does not make any guarantee, express or implied, with respect to the performance and reliability of third-party products, as well as potential impacts of operations on the products.
Description
An error is reported when cloud database version RDS for SQL Server modifies the table structure, as shown in the following figure.
Causes
Apsaradb for RDS for SQL Server has enabled the
Prevent saving changes that require the table re-creation option causes an error.
Solutions
Alibaba Cloud reminds you that:
When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
Click Tools > Designers > Table and Database Designers, in Table options lower close Prevent saving changes that require table re-creation option is OK. The Changes you have made require the following table
Application scope
ApsaraDB RDS for SQL Server