I was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;
I’d renamed a column which is why the table needed to be dropped and re-created but this should have been possible (I’ve definitely done this before); I also hadn’t changed any options is SQL Server Management Studio.
The option Prevent saving changes that require table re-creation () is in the Options dialog;
It was indeed enabled but I hadn’t been into the Options since loading SQL so being prevented from saving changes which require tables to be dropped and re-created is actually the default option. I unchecked the option and tried resaving the changes to the table; this time successfully.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
2 thoughts on “SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped”