Changing non-nullable column to nullable in SQL Server is quick and painless


In T-SQL, you can only ALTER COLUMN one at a time. Initially I was worried about operational cost of this change, but it turned out this change is instantaneous.

Mind you, I’m not suggesting you should do this without a good reason.

,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.