SQL Server operations to rebuild tables are disabled

When modifying the table, you will get the following prompt, modify the table need to delete after rebuilding.

The solution

In SQL Server Management Studio, choose Tools > Options

Then select Designers on the left and there is an option under which the table will be disabled if the table needs to be rebuilt while the table is being adjusted.

Deselect the above options before performing the operation.

The main reason for this problem is that the table is rebuilt when it is created, which is prohibited by the default of the tool.