ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== createDatabase ======
~~NOTOC~~
<WRAP right box>
==Syntax==
  string createDatabase(
      string $databaseName,
      optional mixed $databaseOptions=false
  )
</WRAP>
===== 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 ====
<code php>
/*
* 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
)
*/
</code>

===== 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