Altering Tables

ALTER TABLE has been extended.

In addition to changes for entity and referential integrity, the following types of alterations are allowed:

DELETE column
RENAME new-table-name
RENAME old-column TO new-column
Tip: After you create a column, you cannot modify the column data type. To change a data type, drop the column and recreate it with the correct data type.