ALTER TABLE table_name ALTER COLUMN column_name new_data_type(size);
ALTER TABLE table_name ALTER COLUMN column_name datatype; -- Example ALTER TABLE product ALTER COLUMN description VARCHAR(250);
ALTER TABLE dbo.doc_exa ADD column_b VARCHAR(20) NULL, column_c INT NULL ;
ALTER TABLE table_name ADD column_name datatype;
ALTER TABLE table_name ALTER COLUMN column_name datatype; --ex. ALTER TABLE Customers ADD Email varchar(255);
ALTER TABLE table_name MODIFY column_name datatype;
ALTER TABLE table_name ALTER COLUMN column_name datatype;