Altering Columns in a Table
Overview
You have seen how to delete rows
in a table using the DELETE statement. To add, drop (delete), or modify
columns in a table, use the ALTER TABLE statement.
|
General form, ALTER
TABLE statement:
ALTER TABLE table-name
<ADD column-definition-1<,
... column-definition-n>>
<DROP column-name-1<,
... column-name-n>>
<MODIFY column-definition-1<,
... column-definition-n>>;
table-name
specifies the name
of the table in which columns will be added, dropped, or modified.
<ADD, DROP, MODIFY>
at least one of the
following clauses must be specified:
ADD
specifies one or more column-definitions
for columns to be added.
DROP
specifies one or more column-name ... |
Get SAS Certification Prep Guide, 4th Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.