You can drop a table, a view or an index. The data will be lost.

DROP VIEW old_games; DROP INDEX gamesIdx ON games; DROP TABLE games;
DROP VIEW old_games; DROP INDEX gamesIdx; DROP TABLE games; CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012); CREATE VIEW old_games AS SELECT yr,city FROM games WHERE yr<2006; CREATE INDEX gamesIdx ON games(city,yr);

DROP VIEW old_games;
DROP INDEX gamesIdx ON games;
DROP TABLE games;