All Products
Search
Document Center

ApsaraDB RDS:Modify table structure and prompt "The Changes you have made require the following table" error

Last Updated:Aug 24, 2023

Note

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

Note

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. 关闭选项

Application scope

  • ApsaraDB RDS for SQL Server