Alter Command For Add Renaming Column

Alter table command is used to modify the table structure we can add a column or modify column.

Syntax
ALTER TABLE table_name
ADD column_name datatype

eg-alter table test add mobile number(10);

Modifying a column

Syntax

ALTER TABLE “table_name”
RENAME COLUMN “column 1” TO “column 2”;