1DROP ACCESS METHOD(7) PostgreSQL 11.6 Documentation DROP ACCESS METHOD(7)
2
3
4
6 DROP_ACCESS_METHOD - remove an access method
7
9 DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10
12 DROP ACCESS METHOD removes an existing access method. Only superusers
13 can drop access methods.
14
16 IF EXISTS
17 Do not throw an error if the access method does not exist. A notice
18 is issued in this case.
19
20 name
21 The name of an existing access method.
22
23 CASCADE
24 Automatically drop objects that depend on the access method (such
25 as operator classes, operator families, and indexes), and in turn
26 all objects that depend on those objects (see Section 5.13).
27
28 RESTRICT
29 Refuse to drop the access method if any objects depend on it. This
30 is the default.
31
33 Drop the access method heptree:
34
35 DROP ACCESS METHOD heptree;
36
38 DROP ACCESS METHOD is a PostgreSQL extension.
39
41 CREATE ACCESS METHOD (CREATE_ACCESS_METHOD(7))
42
43
44
45PostgreSQL 11.6 2019 DROP ACCESS METHOD(7)