ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE…