how to add multiple columns in alter statement

Question

how to add multiple columns in alter statement, anyone can help

Rajanikant Hawaldar · Answer

ALTER TABLE a_table ADD COLUMN col1 integer NOT NULL DEFAULT 0, ADD COLUMN col2 text; and so on

satheesh d · Answer

In the SQL, the ALTER command is used to ADD, DROP, MODIFY the existing table with the newly updated fields. Here ADD command is used to adding new columns to an existing table. For Example, if the table consists of four columns and I want to add more columns, then ADD command can be used and the position of inserting new column can also be chosed. For Adding new column in specific positions, ALTER TABLE[sample].[dbo].[USER] ADD COLUMN DOB Date NULL, ADD COLUMN Phone nvarchar(10) NULL AFTER LASTNAME;

Abhishek Chadha · Answer

I don't know for which DB type you want to alter multiple Columns, but you can refer to below article and alter any DB Type - https://www.techonthenet.com/sql/tables/alter_table.php

Varun Setia · Answer

Here is one example, ALTER TABLE employees ADD last_name VARCHAR(50), first_name VARCHAR(40);

Vinitha T · Answer

Alter statement can be used to add, modify, drop, rename a column and to rename table. Add Multiple column, Syntax: ALTER TABLE tableName ADD columnName1 columnDefinition, columnName2 columnDefinition;

Ganesan C · Answer

Please refer below link. https://www.sqltutorial.org/sql-add-column/

how to add multiple columns in alter statement

Answers (6)