Thursday , February 21 2019
Home / DataBase / SQL SERVER / Create a Database In SQL Server

Create a Database In SQL Server

Create a Database In SQL Server

Database:- A Database is a Systematic Collection of Data.It Contains Tables,Rows and Columns.

Database Management System:-A Database Management System is a Collection of programs that enables you store,Modify and Extract Information from a Database.


In SQL Server Management Studio We can Create a Database In Two Ways :

1.Graphically and

2. Using a Query.

1.Graphically:-  After Connecting SQL Server

1.Right Click On Databases  -> Then Select New Database…

2.Give the Database name in Database name  text box ->  Then Click On OK Button..It Creates the Database.

Then You Should Expand the Databases folder and you will see Database name Created there..


2.Using a Query :- We can also Create a Database using a Query.

1.Take New Query Window editor then

2. Write a query in that window


Create Database <DatabaseName>


Create Database Sample



then Refresh the Databases Folder you will see Database name what ever you creates here you will see Database name Sample in Databases Folder.




Print Friendly, PDF & Email

Give us your valuable feedback


About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …