MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
Collection::dropIndex
Drop collection index
public bool mysql_xdevapi\Collection::dropIndex(string index_name);
Drop a collection index.
This operation does not yield an error if the index does not
exist, but false
is returned in that case.
index_name
Name of collection index to drop.
true
if the DROP INDEX operation succeeded,
otherwise false
.
Example 5.16 mysql_xdevapi\Collection::dropIndex
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $session->sql("DROP DATABASE IF EXISTS addressbook")->execute(); $session->sql("CREATE DATABASE addressbook")->execute(); $schema = $session->getSchema("addressbook"); $create = $schema->createCollection("people"); // ... $collection = $schema->getCollection("people"); $collection->createIndex( 'myindex', '{"fields": [{"field": "$.name", "type": "TEXT(25)", "required": true}], "unique": false}' ); // ... if ($collection->dropIndex('myindex')) { echo 'An index named 'myindex' was found, and dropped.'; } ?>
The above example will output:
An index named 'myindex' was found, and dropped.