ALTER

Using Alter Statement we Can Modify column name Add column and Change Data Types

ADD Statement

ALTER TABLE QueryPanel_Employees ADD COLUMN shift VARCHAR(255);

MODIFY Statement

ALTER TABLE QueryPanel_employees MODIFY COLUMN shift char(25);

CHANGE NAME

ALTER TABLE QueryPanel_employees CHANGE COLUMN shift shift_time varchar(225);

DROP COLUMN

ALTER TABLE QueryPanel_employees DROP COLUMN Shift_time;

MULTIPLE COLUMN ADD

ALTER TABLE QueryPanel_employees ADD COLUMN Shift VARCHAR(255),ADD COLUMN Timing DATETIME(6);

Leave a Reply

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