php8.5
Home/ Manual/ mysql_xdevapi / table/ Table::isView

Table::isView

PHP function Edit on GitHub ✎

Check if table is view

Description

mysql_xdevapi\Table::isView(): bool

Determine if the underlying object is a view or not.

Parameters Parameters

Return Values

true if the underlying object is a view, otherwise false.

Examples

mysql_xdevapi\Table::isView() example

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

$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();
$session->sql("CREATE TABLE addressbook.names(name text, age int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();

$schema = $session->getSchema("addressbook");
$table  = $schema->getTable("names");

if ($table->isView()) {
    echo "This is a view.";
} else {
    echo "This is not a view.";
}
?>

The above example will output:

output
This is not a view.

Source: reference/mysql_xdevapi/mysql_xdevapi/table/isview.xml · from the official PHP manual (php/doc-en)