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 table by using my_virtual_am, you need my_virtual_am to
execute the DROP TABLE statement before you can execute DROP ACCESS_METHOD.