The DROP ACCESS_METHOD (+) statement
Use the DROP ACCESS_METHOD statement to remove a previously defined access method from the database.
Syntax
DROPACCESS_METHODaccess-method
nameRESTRICT
| Element | Purpose | Restrictions | Syntax |
|---|---|---|---|
| access-method name | The access method to drop | The access method must be registered in the sysams system catalog table with a previous CREATE ACCESS_METHOD statement. | Database Object Name segment; see Informix® Guide to SQL: Syntax. |
Usage
The RESTRICT keyword is required. You cannot drop an access method if indexes exist that use that access method.
If a transaction is in progress, the database server waits to drop the access method until the transaction is committed or rolled back. No other users can execute the access method until the transaction has completed.
You must own the access method or have the DBA privilege to use the DROP ACCESS_METHOD statement.