Question

Explain the syntax of ALTER Table.

Answer 1

Answer

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

ALTER TABLE - ADD Column

To add a column in a table, use the following syntax:

ALTER TABLE table_name

ADD column_name datatype;

Answer 2

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype

Example

The following SQL adds an "Email" column to the "Customers" table:

ALTER TABLE Customers
ADD Email varchar(255);

please mark it as brainliest