Create a database or schema definition
The CREATE DATABASE statement is used to introduce the database definition for a new database. The definition is contained in the sequence of DDL statements (CREATE DOMAIN or CREATE TABLE) that are submitted immediately following this statement. The name of the database is specified by the database_name identifier.
The database is automatically created and initialized upon the successful compilation of all of its subsequent DDL statements and execution of the first non-DDL statement (usually COMMIT) that follows the DDL statements. At that point, the database is open and ready for use. If encryption is enabled, the database encryption key will automatically be created for this connection.
Only one CREATE DATABASE can be issued in a given connection and no other databases can be opened when the CREATE DATABASE is issued.
This statement can only be executed through SQL. It is not recognized by the
create database bookshop; create table author( last_name char(11) primary key, full_name char(35), gender char(1), yr_born smallint, yr_died smallint, short_bio varchar(250) ); ... other DDL statements for the bookshop database commit;