PDO rename table Function rename a table from database operation using PDOModel

Description

Rename table function allows to rename a table specifying the old table-name and new table-name

Function Defination

  
                                void function renameTable($oldDBTableName, $newDBTableName);

Parameters Details

Details Type Example
$oldDBTableName - table name to be renamed from database string e.g. "emptable"
$newDBTableName - new table name string e.g. "empnewtable"

Examples

  
                                $pdomodel = new PDOModel(); //create object of the PDOModel class
                                $pdomodel->connect("localhost", "root", "", "pdocrud");//connect to database
                                /* Get all tables function */
                               $pdomodel->renameTable("country", "countryTable");

More Examples

 
                                //Example 1 - with column fetch mode
                                if($pdomodel->renameTable("dbtablename", "newtablename");)
                                    echo "table renamed";;

Result/Output

Return true if table renamed successfully

Debug

Option Details Example
$pdomodel->getLastQuery(); Return last query executed RENAME TABLE `dbtablename` TO `newtablename`
print_r($pdomodel->error) Print errors (if any)