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 earlier in this chapter.) 
proc sql;
   drop index daily
      from work.marchflights;
When this step is submitted, the SAS log displays a message indicating that the index has been dropped.
Table 6.11 SAS Log 
NOTE: Index daily has been dropped.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.30.210