NAME
DROP OPERATOR CLASS - 删除一个操作符类
SYNOPSIS
DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]
DESCRIPTION 描述
DROP OPERATOR CLASS 从数据库中删除一个现有操作符表。要执行这条命令，你必须是此操作符表的所有者。
PARAMETERS 参数
- name
一个现存操作符表的名字（可以用模式修饰）。- index_method
操作符表所对付的索引访问方法的名字。- CASCADE
自动删除依赖于该操作符表的对象。- RESTRICT
如果有任何依赖对象存在，则拒绝删除此操作符表。这个行为是缺省。
EXAMPLES 例子
删除 B-tree 操作符表 widget_ops：
DROP OPERATOR CLASS widget_ops USING btree;
如果有任何现存的索引使用这个操作符表，那么这条命令将不能 执行。增加一个 CASCADE 删除这样的索引以及这个 操作符表。
COMPATIBILITY 兼容性
在 SQL 标准里没有 DROP OPERATOR CLASS。
SEE ALSO 参见
ALTER OPERATOR CLASS [alter_operator_class(7)], CREATE OPERATOR CLASS [create_operator_class(l)]
#p#
NAME
DROP OPERATOR CLASS - remove an operator class
SYNOPSIS
DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]
DESCRIPTION
DROP OPERATOR CLASS drops an existing operator class. To execute this command you must be the owner of the operator class.
PARAMETERS
- name
- The name (optionally schema-qualified) of an existing operator class.
- index_method
- The name of the index access method the operator class is for.
- CASCADE
- Automatically drop objects that depend on the operator class.
- RESTRICT
- Refuse to drop the operator class if any objects depend on it. This is the default.
EXAMPLES
Remove the B-tree operator class widget_ops:
DROP OPERATOR CLASS widget_ops USING btree;
This command will not succeed if there are any existing indexes that use the operator class. Add CASCADE to drop such indexes along with the operator class.
COMPATIBILITY
There is no DROP OPERATOR CLASS statement in the SQL standard.
SEE ALSO
ALTER OPERATOR CLASS [alter_operator_class(7)], CREATE OPERATOR CLASS [create_operator_class(l)]
