Syntax:
CREATE DATABASE dbname
[ IN dbspace ]
[ { WITH [ LOCATION = 'dbpath' ] [ TEMPLATE = template ] [ ENCODING = encoding ] }
| { WITH [ BUFFERED ] LOG }
| { WITH LOG MODE ANSI } ]
Description:
Creates a new database in the database management system. Attention, the syntax and the options vary from database system to database system.
Example (common):
CREATE DATABASE example;
Creates a new database with name example.
Example (Postgresql):
CREATE DATABASE expamle WITH LOCATION = '/var/lib/postgresql/data' ENCODING='utf-8'
Creates a new database examle, which uses utf-8 as character encoding and is phisically stored in
'/var/lib/postgresql/data'.
Example (Informix):
CREATE DATABASE expamle IN dbsl01 WITH BUFFERED LOG;
Creates in DB-Slice dbsl01 a new database example with buffered logging turned on.
Copyright © 2009. This Object (page with whole content) is open source and can be modifyed and/or copyed unter der terms and conditions of the Universal General Public License (UGPL). This statement does not apply to the UGPL, the copyright statement of this site itself and the logo (top left image on each page). The logo image may be copyed with the page itself, but changing it is not allowed. All other rights on this image are reserved too.