public function getTables()
    {
        $cmd = array(
            'mysql' => array(
                "show tables"),
            'sqlite2?' => array(
                "SELECT name FROM sqlite_master WHERE type='table' AND name!='sqlite_sequence'"),
            'pgsql|sybase|dblib' => array(
                "select table_name from information_schema.tables where table_schema = 'public'"),
            'mssql|sqlsrv|odbc' => array(
                "select table_name from information_schema.tables"),
            'ibm' => array("select TABLE_NAME from sysibm.tables"),
        );
        $query = $this->findQuery($cmd);
        if (!$query[0]) return false;
        $tables = $this->db->exec($query[0]);
        if ($tables && is_array($tables) && count($tables) > 0)
            foreach ($tables as &$table)
                $table = array_shift($table);
        return $tables;
    }
public function getTables()
    {
        $cmd = array(
            'mysql' => array(
                "show tables"),
            'sqlite2?' => array(
                "SELECT name FROM sqlite_master WHERE type='table' AND name!='sqlite_sequence'"),
            'pgsql|sybase|dblib' => array(
                "select table_name from information_schema.tables where table_schema = 'public'"),
            'mssql|sqlsrv|odbc' => array(
                "select table_name from information_schema.tables"),
            'ibm' => array("select TABLE_NAME from sysibm.tables"),
        );
        $query = $this->findQuery($cmd);
        if (!$query[0]) return false;
        $tables = $this->db->exec($query[0]);
        if ($tables && is_array($tables) && count($tables) > 0)
            foreach ($tables as &$table)
                $table = array_shift($table);
        return $tables;
    }
public function getTables ( ) { $ cmd = array ( 'mysql' => array ( "show tables" ) , 'sqlite2?' => array ( "SELECT name FROM sqlite_master WHERE type='table' AND name!='sqlite_sequence'" ) , 'pgsql|sybase|dblib' => array ( "select table_name from information_schema.tables where table_schema = 'public'" ) , 'mssql|sqlsrv|odbc' => array ( "select table_name from information_schema.tables" ) , 'ibm' => array ( "select TABLE_NAME from sysibm.tables" ) , ) ; $ query = $ this -> findQuery ( $ cmd ) ; if ( ! $ query [ 0 ] ) return false ; $ tables = $ this -> db -> exec ( $ query [ 0 ] ) ; if ( $ tables && is_array ( $ tables ) && count ( $ tables ) > 0 ) foreach ( $ tables as & $ table ) $ table = array_shift ( $ table ) ; return $ tables ; }
get all tables of current DB
@return bool|array list of tables, or false
get all tables of current DB