New Metadata-Only Column Changes in SQL Server 2016

(Paul White) The ALTER TABLE … ALTER COLUMN command is very powerful. You can use it to change a column’s data type, length, precision, scale, nullability, collation…and many other things besides.

Register to Read