PostgreSQL 文档检索
PG 18 · 按类别浏览,或输入名称与关键词
常用条目12289
DROP ACCESS METHOD移除一个访问方法
DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ]
扩展与访问方法SQL 命令 · 扩展与访问方法
DROP ACCESS METHODDROP ACCESS METHOD DROP ACCESS METHOD — 移除一个访问方法大纲 DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP ACCESS METHOD
DROP AGGREGATE移除一个聚合函数
DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ]
其中 aggregate_signature 是:
* |
[ argmode ] [ argname ] argtype [ , ... ] |
[ [ argmode ] […SQL 命令 · 函数与过程
DROP AGGREGATEDROP AGGREGATE DROP AGGREGATE — 移除一个聚合函数大纲 DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ] 其中 aggregate_signature 是: * | [ argmode ] [ argname ] argt…DROP AGGREGATE
DROP CAST移除一个类型转换
DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP CASTDROP CAST DROP CAST — 移除一个类型转换大纲 DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]DROP CAST
DROP COLLATION删除一个排序规则
DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP COLLATIONDROP COLLATION DROP COLLATION — 删除一个排序规则大纲 DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP COLLATION
DROP CONVERSION移除一个转换
DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP CONVERSIONDROP CONVERSION DROP CONVERSION — 移除一个转换大纲 DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP CONVERSION
DROP DATABASE移除一个数据库
DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]
其中 option 可以是:
FORCE
数据库、模式与表空间SQL 命令 · 数据库、模式与表空间
DROP DATABASEDROP DATABASE DROP DATABASE — 移除一个数据库大纲 DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] 其中 option 可以是: FORCEDROP DATABASE
DROP DOMAIN移除一个域
DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP DOMAINDROP DOMAIN DROP DOMAIN — 移除一个域大纲 DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP DOMAIN
DROP EVENT TRIGGER移除一个事件触发器
DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
触发器与规则SQL 命令 · 触发器与规则
DROP EVENT TRIGGERDROP EVENT TRIGGER DROP EVENT TRIGGER — 移除一个事件触发器大纲 DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP EVENT TRIGGER
DROP EXTENSION移除一个扩展
DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
扩展与访问方法SQL 命令 · 扩展与访问方法
DROP EXTENSIONDROP EXTENSION DROP EXTENSION — 移除一个扩展大纲 DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP EXTENSION
DROP FOREIGN DATA WRAPPER移除一个外部数据包装器
DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
外部数据SQL 命令 · 外部数据
DROP FOREIGN DATA WRAPPERDROP FOREIGN DATA WRAPPER DROP FOREIGN DATA WRAPPER — 移除一个外部数据包装器大纲 DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP FOREIGN DATA WRAPPER
DROP FOREIGN TABLE移除一个外部表
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
外部数据SQL 命令 · 外部数据
DROP FOREIGN TABLEDROP FOREIGN TABLE DROP FOREIGN TABLE — 移除一个外部表大纲 DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP FOREIGN TABLE
DROP FUNCTION移除一个函数
DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...]
[ CASCADE | RESTRICT ]
函数与过程SQL 命令 · 函数与过程
DROP FUNCTIONDROP FUNCTION DROP FUNCTION — 移除一个函数大纲 DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION
DROP GROUPDROP GROUP DROP GROUP — 移除一个数据库角色大纲 DROP GROUP [ IF EXISTS ] name [, ...]DROP GROUP
DROP GROUP移除一个数据库角色
DROP GROUP [ IF EXISTS ] name [, ...]
角色与权限SQL 命令 · 角色与权限
DROP INDEX移除一个索引
DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
索引与统计SQL 命令 · 索引与统计
DROP INDEXDROP INDEX DROP INDEX — 移除一个索引大纲 DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP INDEX
DROP LANGUAGE移除一种过程语言
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
函数与过程SQL 命令 · 函数与过程
DROP LANGUAGEDROP LANGUAGE DROP LANGUAGE — 移除一种过程语言大纲 DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP LANGUAGE
DROP MATERIALIZED VIEW移除一个物化视图
DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
表与视图SQL 命令 · 表与视图
DROP MATERIALIZED VIEWDROP MATERIALIZED VIEW DROP MATERIALIZED VIEW — 移除一个物化视图大纲 DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP MATERIALIZED VIEW
DROP OPERATOR移除一个操作符
DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , right_type ) [, ...] [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP OPERATORDROP OPERATOR DROP OPERATOR — 移除一个操作符大纲 DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , right_type ) [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR
DROP OPERATOR CLASS移除一个操作符类
DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP OPERATOR CLASSDROP OPERATOR CLASS DROP OPERATOR CLASS — 移除一个操作符类大纲 DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR CLASS
DROP OPERATOR FAMILY移除一个操作符族
DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]
类型与运算符SQL 命令 · 类型与运算符
DROP OPERATOR FAMILYDROP OPERATOR FAMILY DROP OPERATOR FAMILY — 移除一个操作符族大纲 DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR FAMILY
DROP OWNED移除一个数据库角色所拥有的数据库对象
DROP OWNED BY { name | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]
角色与权限SQL 命令 · 角色与权限
DROP OWNEDDROP OWNED DROP OWNED — 移除一个数据库角色所拥有的数据库对象大纲 DROP OWNED BY { name | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]DROP OWNED
更多结果
输入名称或关键词,从 PostgreSQL 手册与扩展目录中直接找到定义。
pg17: 限定版本 ex: 只搜扩展 ↑↓ 选择 ↵ 打开