CREATE DATABASE

The CREATE DATABASE statement is used to create on a Valentina Server new database with the specified name.

CREATE DATABASE [IF NOT EXISTS] db_name [WITH vext_set_property]
 
vext_set_property
    :    SET PROPERTY property_name_list OF DATABASE TO property_value_list
 
property_name_list
    :    property_name, ...
 
property_value_list
    :    property_value, ...

The IF NOT EXISTS option allows you suppress the error message in case if such database already exists.

NOTE: 'IF NOT EXISTS' syntax Valentina have taken from MySQL world.

The name for a new database.

This command requires the admin privileges.

CREATE DATABASE people

CREATE DATABASE people
WITH SET PROPERTY "Mode" OF DATABASE TO ‘kDsc_Dat_Blb_Ind’;