Updating Tables
Adding a Column
Deleting a Column
Deleting Tables
6
Renaming a Table
Adding a Primary Key
Adding a Foreign Key
2
Deleting a Foreign Key
Adding an Index
Adding a Unique Index
Deleting an Index
ALTER
TABLE
Orders
ADD
customer_id
INTEGER
NOT
NULL
Although
all
DBMSs support
ALTER
TABLE
, what they allow you to
alter
varies dramatically
from
one to another. To
add
a column, use the
ADD
clause, which specifies the name
and
type of the column.