How will you change the datatype of a column?

1.	How will you change the datatype of a column?
Answer» This can be DONE by using the ALTER TABLE statement as shown below: SYNTAX: ALTER TABLE tnameALTER COLUMN col_name [SET DATA] TYPE new_data_type;

Answer»

This can be DONE by using the ALTER TABLE statement as shown below:

ALTER TABLE tnameALTER COLUMN col_name [SET DATA] TYPE new_data_type;

Discussion