SQL CREATE DATABASE

SQL > Data Definition Language (DDL) > Create Database Statement

A database is a collection of organized data. A database is not the same as the Relational Database Management System (RDBMS). An RDBMS can have one or multiple databases, whereas a database can only belong to one RDBMS. On the other hand, a database can contain one or more tables, whereas a table can only belong to a database.

Therefore, the first step to use RDBMS to store data is to create a database. SQL offers the CREATE DATABASE command, and its syntax is,

CREATE DATABASE "database_name";

If we want to create a database called "HOLIDAYS", we would type in,

CREATE DATABASE HOLIDAYS;

Next: SQL DROP DATABASE

This page was last updated on October 11, 2024.

SQL Tutorial
Basic SQL Commands
SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL Wildcard
SQL LIKE
SQL ILIKE
SQL ORDER BY
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL AS
SQL SELECT UNIQUE
SQL JOIN
SQL INNER JOIN
SQL OUTER JOIN
SQL LEFT OUTER JOIN
SQL CROSS JOIN
SQL INSERT INTO
SQL INSERT INTO SELECT
SQL UPDATE
SQL DELETE FROM
COMMENT
Advanced SQL
SQL UNION
SQL UNION ALL
SQL Inline View
SQL INTERSECT
SQL MINUS
SQL LIMIT
SQL TOP
SQL Subquery
SQL WITH
SQL EXISTS
SQL CASE
SQL PIVOT
Window Functions
SQL DECODE
SQL COMMIT
SQL AUTO INCREMENT
SQL IDENTITY
SEQUENCE & NEXTVAL
SQL Functions
SQL Average
SQL COUNT
SQL MAX
SQL MIN
SQL SUM
SQL ROUND
String Functions
SQL CAST
SQL CONVERT
SQL CONCATENATE
SQL SUBSTRING
SQL INSTR
SQL TRIM
SQL LENGTH
SQL REPLACE
SQL TO_DATE
Date Functions
SQL DDL
SQL CREATE TABLE
SQL Data Types
SQL View
SQL CREATE VIEW
SQL Index
SQL CREATE INDEX
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL USE
SQL CREATE DATABASE
SQL DROP DATABASE
SQL GRANT
SQL REVOKE
SQL CONSTRAINT
NOT NULL Constraint
DEFAULT Constraint
UNIQUE Constraint
CHECK Constraint
PRIMARY KEY
FOREIGN KEY
SQL ALTER TABLE
Add Column
Change Column
Modify Column
Rename Column
Drop Column
Add Index
Drop Index
Add Constraint
Drop Constraint
SQL NULL
SQL ISNULL Function
SQL IFNULL Function
SQL NVL Function
SQL Coalesce Function
SQL NULLIF Function
SQL Video Tutorial
SQL Syntax
SQL Quiz
Sitemap
Resources

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.