Indexes, Removing
In Oracle, DB2, and PostgreSQL, you remove an index by naming it in a DROP INDEX statement:
DROP INDEX falls_name;
SQL Server and MySQL require you to also specify the table name:
DROP INDEX falls_name ON upfall;
Get SQL Pocket Guide, 2nd 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.
