drop_access_method(7)

NAME#

DROP_ACCESS_METHOD - remove an access method

SYNOPSIS#

DROP ACCESS METHOD [ IF EXISTS ] \nname\n [ CASCADE | RESTRICT ]

DESCRIPTION#

DROP ACCESS METHOD removes an existing access method. Only superusers can drop access methods.

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

Drop the access method heptree:

DROP ACCESS METHOD heptree;

COMPATIBILITY#

DROP ACCESS METHOD is a PostgreSQL extension.

SEE ALSO#

CREATE ACCESS METHOD (CREATE_ACCESS_METHOD(7))