How to add a new column to an existing SQL table using the ALTER TABLE statement.

Question

Aryan Kumar · Answer

Sure, I can help you with that.

To add a new column to an existing SQL table using the ALTER TABLE statement, you can use the following syntax:

SQL

ALTER TABLE table_name ADD column_name data_type [constraint];

The table_name is the name of the table to which you want to add the column. The column_name is the name of the new column. The data_type is the data type of the new column. The constraint is an optional clause that specifies any constraints on the new column.

For example, the following statement will add a new column named age of type int to the customers table:

SQL

ALTER TABLE customers ADD age int;

The following statement will add a new column named country of type varchar(255) to the customers table and set the default value to "USA":

SQL

ALTER TABLE customers ADD country varchar(255) DEFAULT 'USA';

You can also use the ALTER TABLE statement to add multiple columns to a table. For example, the following statement will add two new columns named age and country to the customers table:

SQL

ALTER TABLE customers ADD age int, country varchar(255);

It is important to note that when you add a new column to a table, the new column will be added to the end of the table. This means that any existing data in the table will not be affected by the addition of the new column.

forum

How to add a new column to an existing SQL table using the ALTER TABLE statement.

Can you answer this question?

1 Answers