Add Column to Existing SQL Table

1 year ago
Emily Johnson
1 minute

To add a column to an existing table, you can use the ALTER TABLE statement. Here is an example:

ALTER TABLE table_name
ADD column_name data_type;

In this case, table_name is the name of the table where the column is to be added, column_name is the name of the column to be added, and data_type is the data type of the new column. For example, if you want to add a new column called email with a data type of VARCHAR(50) to a table named customers, you can execute the following SQL statement:

ALTER TABLE customers
ADD email VARCHAR(50);

This successfully added a new column named email in the customers table.

bannerAds