v5:dictionary:createdatabase
This is an old revision of the document!
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
- In the driver current in use does not support the method, false is returned
v5/dictionary/createdatabase.1452647187.txt.gz · Last modified: 2017/04/21 11:28 (external edit)