Altering Columns in a Table


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>>;
Here is an explanation of the syntax:
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:
specifies one or more column-definitions for columns to be added.
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.