Specifying The Database Dialect

Specifying the Database Dialect

Databases are created in Dialect 3 by default.For the database to be created in Dialect 1, you will need to execute the statement SET SQL DIALECT 1 from script or the client application, e.g. in isql, before the CREATE DATABASE statement.

Who Can Create a Database

The CREATE DATABASE statement can be executed by:

Administrators
Users with the CREATE DATABASE privilege