* echo $dialect->tableExists("posts", "blog");
* echo $dialect->tableExists("posts");
*
*
* @param string $tableName
* @param string $schemaName
* @return string
*/
public function tableExists($tableName, $schemaName=null){ }
/**
* Generates SQL checking for the existence of a schema.view
*
* @param string $viewName
* @param string $schemaName
* @return string
*/
public function viewExists($viewName, $schemaName=null){ }
/**
* Generates SQL describing a table
*
*
* print_r($dialect->describeColumns("posts")) ?>
*
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeColumns($table, $schema=null){ }
/**
* List all tables on database
*
*
* print_r($dialect->listTables("blog")) ?>
*
*
* @param string $schemaName
* @return array
*/
public function listTables($schemaName=null){ }
/**
* Generates the SQL to list all views of a schema or user
*
* @param string $schemaName
* @return array
*/
public function listViews($schemaName=null){ }
/**
* Generates SQL to query indexes on a table
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeIndexes($table, $schema=null){ }
/**
* Generates SQL to query foreign keys on a table
*
* @param string $table
* @param string $schema
* @return string
*/
public function describeReferences($table, $schema=null){ }
/**
* Generates the SQL to describe the table creation options
*
* @param string $table
* @param string $schema
* @return string
*/
public function tableOptions($table, $schema=null){ }
}
}