Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.
>>-DROP--ACCESS_METHOD--access_method--RESTRICT----------------><
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| access_method | Name of access method to drop | Must be registered in sysams system catalog table; cannot be a built-in access method | Identifier |
| owner | Owner of the access method | Must own the access method | Owner Name |
The RESTRICT keyword is required. You cannot drop an access method if virtual tables or indexes exist that use the access method. You must be the owner of the access method or have DBA privileges to drop an 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.
Related statements: ALTER ACCESS_METHOD and CREATE ACCESS_METHOD
For a description of the RESTRICT keyword, see Specifying RESTRICT Mode. For more information on primary-access methods, see the IBM Informix Virtual-Table Interface Programmer's Guide.
For more information on secondary-access methods, see the IBM Informix Virtual-Index Interface Programmer's Guide. For a discussion of privileges, see the GRANT statement or the IBM Informix Database Design and Implementation Guide.