“不允许保存更改"将现有列更改为可为空时

我有一个 SQL 数据库表，其中有 35 条现有记录.此表中的字段之一称为Name、nvarchar(100)、not null

I've got a SQL Database Table, which has 35 existing records. One of the fields in this table is called Name, nvarchar(100), not null

但是，由于最近的更改，我需要将此列设为可空.

However, due to a recent change, I need to make this column nullable.

当我在 SQL Server Management Studio 中更改列以允许空值并保存更改时，出现以下错误:

When I change the column to allow nulls in SQL Server Management Studio, and go to save my changes, I get the following error:

不允许保存更改.您所做的更改需要将删除并重新创建以下表

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created

如何允许它自动删除并重新创建?

How can I allow this to automatically be dropped and re-created?