DATABASE

SQL DATABASE Keyword

The DATABASE keyword is used with SQL commands like CREATE and DROP to manage whole databases. You can create new databases to store tables and data separately or delete existing ones when they are no longer needed.

SQL CREATE DATABASE Syntax

CREATE DATABASE database_name

CREATE DATABASE database_name

SQL CREATE DATABASE Example

This statement creates a new database named testDB.

CREATE DATABASE testDB;

CREATE DATABASE testDB;

Note: This command will not work in SQLite including our TechKubo playground. In SQLite, databases are created as individual files outside SQL, usually through our application or file system. The playground automatically loads a built-in database that you can use without needing to create one.

SQL SHOW DATABASES Syntax

This command is used to list all available databases.

SHOW DATABASES;

SHOW DATABASES;

Note: This command is not supported in SQLite. It works in systems like MySQL.

SQL DROP DATABASE Syntax

DROP DATABASE database_name;

DROP DATABASE database_name;

SQL DROP DATABASE Example

This deletes the entire database named testDB, including all its tables and data.

DROP DATABASE testDB;

DROP DATABASE testDB;

Note: This command is also not supported in SQLite. In SQLite, you delete a database by deleting the file manually from your file system.

SQL DATABASE Labs