How to change the datatype of a column in SQL?

Question

Can anyone tell me how to change the datatype of a column in SQL?

Answer 1

In MS SQL, here is the syntax to change the datatype of a column:

ALTER TABLE table_name

ALTER COLUMN  ColumnName datatype;

In MySQL, here is the syntax to rename the column:

ALTER TABLE table_name

MODIFY COLUMN  ColumnName datatype;

If you want to learn SQL, you can enroll for this SQL course program by Intellipaat.