print_r($dialect->listTables('blog'));
public listTables ( string $schemaName = null ) : string | ||
$schemaName | string | |
return | string |
public function listTables($schemaName = null)
{
$baseQuery = "SELECT TABLE_NAME, OWNER FROM ALL_TABLES %s ORDER BY OWNER, TABLE_NAME";
if (!empty($schemaName)) {
$schemaName = $this->escapeSchema($schemaName);
return sprintf($baseQuery . 'WHERE OWNER = %s', Text::upper($schemaName));
}
return sprintf($baseQuery, '');
}