Switch to: V9V8V7V6V5

CREATE DATABASE

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

Syntax

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, ...

Arguments

IF NOT EXISTS

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.

db_name

The name for a new database.

Notes

This command requires the admin privileges.

Examples

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