CREATE DATABASE

SQL CREATE DATABASE Keyword

The CREATE DATABASE command is used to create a new database in SQL. This allows you to start organizing tables data and other objects under a specific database name.

SQL CREATE DATABASE Syntax

CREATE DATABASE database_name

CREATE DATABASE database_name

SQL CREATE DATABASE Example

This statement creates a new database named EngineDB.

CREATE DATABASE EngineDB

CREATE DATABASE EngineDB

Note: SQLite including our TechKubo playground does not support the CREATE DATABASE command. In SQLite a new database is created as a new file outside SQL usually through a database interface or application setup.

SQL SHOW DATABASES Syntax

This command lists all databases available in the system.

SHOW DATABASES

SHOW DATABASES

Note: This command is supported in MySQL but not in SQLite. In the TechKubo playground you are limited to a single built-in database and cannot list or switch databases.

SQL CREATE DATABASE Labs