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


Create Database "Database_Name";


Create Database MyFirstDB;

How To Rename A Database


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


Alter Database MyFirstDB Modify Name = MyFirstDataBase;

How To Delete A Database


Drop Database "Database_Name";


Drop Database MyFirstDataBase;

How To Create Database in SQL Server 2017 Management Studio

Share On