sqldatabaseamazon-web-servicesamazon-redshift

How to add multiple columns in AWS redshift with alter table query

Is it possible to add multiple columns in a single Alter query in Redshift

Alter table employee add column Name, add column Age, add column Salary

Solution

  • According to Redshift Documentation, You can add only one column in each ALTER TABLE statement. Only way to add multiple columns is executing multiple ALTER TABLE statements.