Drop an access method
To drop an access method, use the DROP ACCESS_METHOD statement.
The following example uses the
DROP ACCESS_METHOD statement to drop an access method.
DROP ACCESS_METHOD my_virtual RESTRICTRestriction: Do not drop an access method if database objects
exist that rely on the specified access method for access. For example,
if you create a virtual index using my_virtual_am, you need
to drop the index so my_virtual_am can process the DROP INDEX
statement before you can execute DROP ACCESS_METHOD.