ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:createdatabase

createDatabase

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 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
v5/dictionary/createdatabase.txt · Last modified: 2018/07/01 22:42 by peterdd