Dropping Indexes

Overview

To drop (delete) one or more indexes, use the DROP INDEX statement.
General form, DROP INDEX statement:
DROP INDEX index-name-1 <, ...index-name-2>
FROM table-name;
Here is an explanation of the syntax:
index-name
specifies an index that exists.
table-name
specifies a table that contains the specified index(es). The table-name can be one of the following:
  • a one-level name
  • a two-level libref.table name
  • a physical pathname that is enclosed in single quotation marks.

Example: Dropping a Composite Index

The following PROC SQL step uses the DROP INDEX statement to drop the composite, unique index daily from the temporary table Marchflights. (This index was created in an example ...

Get SAS Certification Prep Guide, 4th 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.

Start your free trial