Schema::existsInDatabase

Check if exists in database

Description

public bool mysql_xdevapi\Schema::existsInDatabase()

Checks if the current object (schema, table, collection, or view) exists in the schema object.

Parameters

This function has no parameters.

Return Values

true if the schema, table, collection, or view still exists in the schema, else false.

Examples

Example #1 mysql_xdevapi\Schema::existsInDatabase example

<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

$session->sql("DROP DATABASE IF EXISTS food")->execute();
$session->sql("CREATE DATABASE food")->execute();
$session->sql("CREATE TABLE food.fruit(name text, rating text)")->execute();

$schema = $session->getSchema("food");
$schema->createCollection("trees");

// ...

$trees = $schema->getCollection("trees");

// ...

// Is this collection still in the database (schema)?
if ($trees->existsInDatabase()) {
    echo "Yes, the 'trees' collection is still present.";
}

The above example will output something similar to:

Yes, the 'trees' collection is still present.