Answers for "how to change datatype of column in sql alter table"

alter table add column

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;

Posted by: Guest on April-08-2020

modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';

Posted by: Guest on May-08-2020

Code answers related to "how to change datatype of column in sql alter table"