Drop Column

-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE TABLE SUPERHEROES (
  -- Column called ID allowing up to five characters
  "ID" VARCHAR(5), 
  -- Column called NAME allowing up to 100 characters
  "NAME" VARCHAR(100),
  -- Column called ALTER_EGO allowing up to 100 characters
  "ALTER_EGO" VARCHAR(100)
);

-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES 
    -- With the values
    VALUES
    ('XF6K4', 'Chris Maki', 'The Bomber'),
    ('KD5SK', 'Donny Mav', 'Nuke Miner');

-- View the SUPERHEROES table
SELECT * FROM SUPERHEROES;

-- Alter the SUPERHEROES table by...
ALTER TABLE IF EXISTS SUPERHEROES 
-- Dropping the column called ALTER_EGO
DROP COLUMN ALTER_EGO
;

-- View the SUPERHEROES table
SELECT * FROM SUPERHEROES;