Menu
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.
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?
617
The value 0 is displayed, since we haven't added any value while using INSERT command above. Here is the syntax to allow NULL value. alter table yourTableName modify column yourColumnName datatype; Apply the above syntax to modify the column to allow NULL.
You can add a not null column at the time of table creation or you can use it for an existing table. In the above table, we have declared Id as int type that does not take NULL value. If you insert NULL value, you will get an error.
I've found the solution. Go to "Tools > Options > Designers > Table and Database Designers":
131
It's a setting in SSMS.
Tools - Option - Designers - Prevent saving changes that require table re-creation
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
