The start of data storage is from the creation of a database. As the name suggests database is a base for data. A database typically contains different tables based on the necessity of data storage.
SQL Create Database
In this section, we will see how different databases provides the feature of creating a database. So let’s start with the following set of databases.
- PostgreSQL
- MySQL
- SQLServer
We will try to understand database creation in each of the above mentioned DBs one by one.
PostgreSQL Create Database
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
In order to create a database in PostgreSQL, you must have either superuser privileges or you should have CREATEDB privilege.
Below mentioned are the steps to create a database using PgAdmin (GUI for PostgreSQL).
- Login into server and right click on the PostgreSQL. Select create-> database
- A pop-up will appear where you can provide the details about the database. Example:- DB name, etc.
- Click on save and the new database will be created.
Please find below the images to explain the above steps.
PostgreSQL: Right Click Create Database
PostgreSQL: Create DB popup
The same database can also be created using SQL command. Please find below the command for the same.
|
1 2 3 4 5 |
CREATE DATABASE "TestDB" WITH OWNER = postgres ENCODING = 'UTF8'; |
MySQL Create Database
MySQL is the world’s most popular open source database. We will try to understand how to create a database in MySQL using SQL command.
Syntax for Create Database:
|
1 2 3 |
CREATE DATABASE <database_name> |
Example for creating a database
|
1 2 3 |
CREATE DATABASE TestDB; |
Also for Unix, database names are case-sensitive so please make sure that appropriate case is used.
We can use show databases; to check if the database has been created successfully or not.
MySQL Create Database
SQL Server Create Database
In SQL Server 2017, creating a database is as simple as running a script. SQL Server Management Studio provides a GUI database management tool, by just clicking and pointing on the GUI we can create a database.
- Launch a server
- Connect to the SQL server, provide valid Authentication.
- Right Click on Database and click on New Database.
- PopUp will appear. Enter the name of the database and click on OK.
- The newly created DB will appear in the Object Explorer.
SQLServer Create Database
SQLServer CreateDB Successful
The database is created successfully in SQL Server using SQL Server Management Studio.