            Coding With Fun

Home Docker Django Node.js Articles Python pip guide FAQ Policy

SQL CREATE DATABASE statement

May 16, 2021 SQL

Create DATABASE statements are used to create databases.

In RDBMS, database names should always be unique.

CREATE DATABASE dbname;

Before you create any databases, make sure that you have administrative rights.

SQL CREATE DATABASE instance

The following SQL statement creates a database called my_db " " :

CREATE DATABASE my_db;

Database tables can be added through create TABLE statements.

After you create a database, you can check it in the database list.

Statement:

SHOW DATABASES;