sql server update table column size code example
Example 1: sql alter column size
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
Example 2: sql change column in existing table
'This adds 'NOT NULL' to excisting column counting in the table mytable'
ALTER TABLE mytable ALTER COLUMN counting INT NOT NULL;