pre conditions for changing the data types of column in sql code example
Example 1: sql alter column size
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
Example 2: sqlserver add column to table
ALTER TABLE dbo.doc_exa
ADD column_b VARCHAR(20) NULL,
column_c INT NULL ;