Home | Previous Page | Next Page   Developing an Access Method >

Dropping an Access Method

To drop an access method, execute the DROP ACCESS_METHOD statement, as the following example shows:

DROP ACCESS_METHOD my_virtual RESTRICT

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

For more information, refer to DROP ACCESS_METHOD (+).

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]