Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

ALTER TABLE Examples

The following examples demonstrate basic usage of the ALTER TABLE command.

Rename a Table

The following command renames the USERS table to USERS_BKUP:

Copy
alter table users rename to users_bkup;

You can also use this type of command to rename a view.

Change the Owner of a Table or View

The following command changes the VENUE table owner to the user DWUSER:

Copy
alter table venue owner to dwuser;

The following commands create a view, then change its owner:

Copy
create view vdate as select * from date; alter table vdate owner to vuser;

Rename a Column

The following command renames the VENUESEATS column in the VENUE table to VENUESIZE:

Copy
alter table venue rename column venueseats to venuesize;

Drop a Table Constraint

To drop a table constraint, such as a primary key, foreign key, or unique constraint, first find the internal name of the constraint, then specify the constraint name in the ALTER TABLE command. The following example finds the constraints for the CATEGORY table, then drops the primary key with the name category_pkey.

Copy
select constraint_name, constraint_type from information_schema.table_constraints where constraint_schema ='public' and table_name = 'category'; constraint_name | constraint_type ----------------+---------------- category_pkey | PRIMARY KEY alter table category drop constraint category_pkey;