How to Modify Datatype in SQL?

Use `ALTER TABLE table_name ALTER COLUMN column_name TYPE new_datatype;`

Use `ALTER TABLE table_name MODIFY column_name new_datatype;`

Use `ALTER TABLE table_name ALTER COLUMN column_name new_datatype;`

Use `ALTER TABLE table_name CHANGE COLUMN old_column_name new_column_name new_datatype;`

Use `ALTER TABLE table_name ALTER COLUMN column_name SET DATA TYPE new_datatype;`

Use `ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT default_value;`

Use `ALTER TABLE table_name ALTER COLUMN column_name DROP DEFAULT;`

Use `ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;`

Use `ALTER TABLE table_name ALTER COLUMN column_name DROP NOT NULL;`

Use `ALTER TABLE table_name ALTER COLUMN column_name USING expression;`