CREATE TABLE IF NOT EXISTS CUSTOMERS(
ID INT NOT NULL,
NAME VARCHAR (20) NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR (25),
SALARY DECIMAL (18, 2),
PRIMARY KEY (ID)
);
ALTER TABLE CUSTOMERS
ADD COLUMN EMAIL VARCHAR(50);
ALTER TABLE CUSTOMERS
CHANGE COLUMN ADDRESS LOCATION CHAR(25);
ALTER TABLE CUSTOMERS
DROP COLUMN LOCATION;
TRUNCATE TABLE CUSTOMERS;
DROP TABLE IF EXISTS CUSTOMERS;