====== createDatabase ======
~~NOTOC~~
==Syntax==
string createDatabase(
string $databaseName,
optional mixed $databaseOptions=false
)
===== Description =====
The method ''createDatabase()'' returns an array of strings holding the SQL necessary to create a database (or user space) on the current DBMS. To actually execute the code, the output must be passes to [[v5:dictionary:executesqlarray]].
===== Usage ====
/*
* On an Oracle system
*/
$dict = newdataDictionary($db);
print_r($dict->createDatabase('ADODB_TEST'));
/*
* Returns
Array
(
[0] => CREATE USER ADODB_TEST IDENTIFIED BY tiger
[1] => GRANT CREATE SESSION, CREATE TABLE,UNLIMITED TABLESPACE,CREATE SEQUENCE TO ADODB_TEST
)
*/
===== Notes =====
* Support for this method is limited
* Each supported database has its own specific options
* Special rights on the database may be need to actually execute the returned SQL
* If the driver current in use does not support the method, false is returned