Login Register

Db\Dialect\Mysql::tableExists

public tableExists (mixed $tableName, [mixed $schemaName])

Generates SQL checking for the existence of a schema.table

echo $dialect->tableExists("posts", "blog");
    echo $dialect->tableExists("posts");

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Db_Dialect_Mysql.html#tableexists

doc_Phalcon

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

Db\Dialect\Mysql extends abstract class Phalcon\Db\Dialect implements Phalcon\Db\DialectInterface Source on GitHub Generates database specific SQL for the MySQL RDBMS

Db\Dialect\Mysql::listTables public listTables ([mixed $schemaName]) List all tables in database print_r($dialect->listTables("blog"))

Db\Dialect\Mysql::dropColumn public dropColumn (mixed $tableName, mixed $schemaName, mixed $columnName) Generates SQL to delete a column from a table

Db\Dialect\Mysql::addIndex public addIndex (mixed $tableName, mixed $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add an index to a table

Db\Dialect\Mysql::viewExists public viewExists (mixed $viewName, [mixed $schemaName]) Generates SQL checking for the existence of a schema.view