Indexes, Removing
In DB2, Oracle, and PostgreSQL, you remove an index by naming it in a DROP INDEX statement:
DROP INDEX falls_name;
MySQL and SQL Server require you to also specify the table name:
DROP INDEX falls_name ON upfall;
Get SQL Pocket Guide, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
