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 example, if you create an 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.

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

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