September 2019
Beginner to intermediate
346 pages
7h 35m
English
Using the ALTER statement, we can drop (delete) columns, modify columns, and add columns. The general form of this statement is as follows:
ALTER TABLE table-name <DROP column-name-1<, ... column-name-n>> <MODIFY column-definition-1<, ... column-definition-n>>; <ADD column-definition-1<, ... column-definition-n>>
Here, table-name specifies the name of the table in which columns will be added, dropped, or modified.
At least one of the following clauses must be specified: