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

ALTER TABLE table_name
ADD column_name datatype

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

Modifying a column


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

Leave a Reply

Your email address will not be published. Required fields are marked *