Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 703
Ravi Avatar asked Feb 03 '26 17:02

Ravi


1 Answers

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.

like image 159
Edgars T. Avatar answered Feb 05 '26 06:02

Edgars T.



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!