ALTER TABLE

(a field data type;

SQL OnLine IDE - ALTER TABLE.mp4

This statement is used to change the datatype of a field or to add / drop a column from a table.

alter table car_sales

add carsales_NumberOfDoors int

alter table car_sales

alter column carsales_NumberOfDoors varchar(10)

alter table car_sales

drop column carsales_NumberOfDoors

EXAM TIP: Past exams show that it is unlikely you will be asked to alter a table in the exam.

The ALTER TABLE statement is not a part of the AQA Specification

AQA Specification

For more exam tips click here....

Page updated

Google Sites

Report abuse