Alter Column Type
How to change a table column type in Amazon RedshiftRename A Column
How to rename a table column in Amazon RedshiftAlter Column Default
How to change a column's default value in Amazon RedshiftAlter Column Nullable
How to change the nullable flag on a Amazon Redshift table columnAlter Table Add Foreign Key
Adding a foreign key (otherwise known as a relation or association) to a Amazon Redshift table means adding a 'constraint'. These basic examples assume that the column type is correct, and any existing values match existing relation IDs in the target table.Alter Table Drop Foreign Key / Constraint
Removing a foreign key (otherwise known as a relation or association) from a Amazon Redshift table. Note that after removing a relation, you might also want to remove any left over indexes.Alter Table
A Amazon Redshift example for changing, adding, and removing columns for an existing table