New Metadata-Only Column Changes in SQL Server 2016
APRIL 17, 2020
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. Improvements in SQL Server 2016. The ALTER TABLE. ALTER COLUMN command is very powerful.