SQL•SQL References

SQL ALTER COLUMN Keyword

Concept visual

SQL ALTER COLUMN Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALTER COLUMN Keyword

Alter Column

The ALTER COLUMN

command is used to change the data type of a column in a table. The following SQL changes the data type of the column named "BirthDate" in the "Employees" table to type year:

Example

ALTER TABLE Employees

ALTER COLUMN BirthDate year;

SQL ALTER COLUMN Keyword

Concept visual

SQL ALTER COLUMN Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALTER COLUMN Keyword

Alter Column

The ALTER COLUMN

command is used to change the data type of a column in a table. The following SQL changes the data type of the column named "BirthDate" in the "Employees" table to type year:

Example

ALTER TABLE Employees

ALTER COLUMN BirthDate year;

SQL ALTER COLUMN Keyword

SQL ALTER COLUMN Keyword

ALTER COLUMN Keyword

Previous

Next

Alter Column

The ALTER COLUMN

Example

ALTER TABLE Employees

Previous

Next

SQL ALTER COLUMN Keyword

SQL ALTER COLUMN Keyword

ALTER COLUMN Keyword

Previous

Next

Alter Column

The ALTER COLUMN

Example

ALTER TABLE Employees

Previous

Next