DROP INDEX — remove an index
DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
CONCURRENTLYDrop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal DROP INDEX acquires an ACCESS EXCLUSIVE lock on the table, blocking other accesses until the index drop can be completed. With this option, the command instead waits until conflicting transactions have completed.
There are several caveats to be aware of when using this option. Only one index name can be specified, and the CASCADE option is not supported. (Thus, an index that supports a UNIQUE or PRIMARY KEY constraint cannot be dropped this way.) Also, regular DROP INDEX commands can be performed within a transaction block, but DROP INDEX CONCURRENTLY cannot. Lastly, indexes on partitioned tables cannot be dropped using this option.
For temporary tables, DROP INDEX is always non-concurrent, as no other session can access them, and non-concurrent index drop is cheaper.
IF EXISTSDo not throw an error if the index does not exist. A notice is issued in this case.
nameThe name (optionally schema-qualified) of an index to remove.
CASCADEAutomatically drop objects that depend on the index, and in turn all objects that depend on those objects (see Section 5.15).
RESTRICTRefuse to drop the index if any objects depend on it. This is the default.
This command will remove the index title_idx:
DROP INDEX title_idx;
DROP INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
| 今天开什么奖 | 宫外孕术后可以吃什么 | 绿豆与什么食物相克 | 炖羊肉都放什么调料 | 庚什么意思 |
| 擦汗表情是什么意思 | 刷墙的白色涂料叫什么 | 三点水弘读什么 | 遥祝是什么意思 | 香茅是什么东西 |
| 超体2什么时候上映 | 尿糖2个加号是什么意思 | 紧张性头痛吃什么药 | 瞽叟是什么意思 | 满天星的花语是什么 |
| 下眼睑跳动是什么原因 | 处女膜在什么位置 | 卫校学什么专业最好 | 大便颜色发黑是什么原因 | 血管炎是什么症状 |
| 鼻塞吃什么药hcv7jop6ns3r.cn | 雌堕什么意思hcv8jop3ns9r.cn | 敌敌畏是什么hcv8jop6ns5r.cn | AC是胎儿的什么意思hcv9jop5ns1r.cn | 什么情况下安装心脏起搏器hcv8jop8ns5r.cn |
| 荨麻疹可以吃什么水果hcv8jop1ns8r.cn | 只是女人容易一往情深是什么歌hcv8jop2ns9r.cn | 再接再厉什么意思hcv9jop0ns2r.cn | 返祖现象什么意思hcv9jop1ns9r.cn | 脚面浮肿是什么原因hcv9jop4ns4r.cn |
| 晚上吃什么有助于睡眠hcv9jop0ns7r.cn | 苗侨伟为什么叫三哥hcv9jop5ns2r.cn | 中国女人裹脚是从什么时候开始hcv8jop2ns2r.cn | 人绒毛膜促性腺激素是什么意思hcv8jop4ns7r.cn | 大拇指指甲凹陷是什么原因hcv8jop1ns5r.cn |
| lad是什么意思hcv9jop1ns7r.cn | 平身是什么意思hcv9jop2ns6r.cn | 公积金缴存基数是什么意思hcv9jop2ns9r.cn | 1993年属什么hcv8jop6ns6r.cn | 脐疝是什么hcv8jop8ns3r.cn |