New Metadata-Only Column Changes in SQL Server 2016
SQL Performance
APRIL 17, 2020
When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. The operation will still require a restrictive schema modification Sch-M lock, but the metadata changes themselves will complete very quickly, regardless of the size of the table.
Let's personalize your content