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. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.
Let's personalize your content