How To Create Database In SQL Server 2017


SQL Database

Database is a systematic collection of data. Databases support storage and manipulation of data. Databases make data management easy.

Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information. Data gets updated, expanded and deleted as new information is added. Databases process workloads to create and update themselves, querying the data they contain and running applications against it.

How To Create A Database

Syntax

Create Database "Database_Name";

Example

Create Database MyFirstDB;

How To Rename A Database

Syntax

Alter Database "Database_Name" Modify Name = "New_Database_Name";

Example

Alter Database MyFirstDB Modify Name = MyFirstDataBase;

How To Delete A Database

Syntax

Drop Database "Database_Name";

Example

Drop Database MyFirstDataBase;

How To Create Database in SQL Server 2017 Management Studio

Share On