SQL ADD Keyword

The ADD keyword in SQL is used with the ALTER TABLE statement to add a new column to an existing table.

SQL ADD Syntax

ALTER TABLE table_name
ADD column_name datatype;

ALTER TABLE table_name

ADD column_name datatype;

SQL ADD Example

This query adds a new column named email of type VARCHAR(255) to the Patients table:

ALTER TABLE Patients
ADD email VARCHAR(255);

ALTER TABLE Patients

ADD email VARCHAR(255);

SQL ADD Labs