DROP

DROP permanently removes database objects (tables, views, indexes, and so forth). See Lesson 17, "Creating and Manipulating Tables," and Lesson 18, "Using Views," for more information.

DROP INDEX|TABLE|VIEW indexname|tablename|viewname;

Get Sams Teach Yourself SQL in 10 Minutes now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.