Alter Table Modify Column Syntax

Table customer
Column Name Data Type
First_Name char(50)
Last_Name char(50)
Address char(50)
City char(50)
Country char(25)
Birth_Date date

Our goal is to alter the data type of the "Address" column to char(100). To do this, we key in:

MySQL:
ALTER TABLE customer MODIFY Address char(100);

Oracle:
ALTER TABLE customer MODIFY Address char(100);

SQL Server:
ALTER TABLE customer ALTER COLUMN Address char(100);

http://www.1keydata.com/sql/alter-table-modify-column.html