How to create a database in a Microsoft SQL server?

0 votes
36 views
Ethan Karla asked 4 days ago in Database by Ethan Karla

How to create a database in a Microsoft SQL server also write query?

1 Answer

0 votes
Ashutosh Kumar Verma answered 3 days ago by Ashutosh Kumar Verma

Create Database in SQL Server :

    There are generally two way to create a new Database in SQL Management Server, that is- 

1- By the use of SQL query  The SQL query which is use to create a new Database is as- 

                           Syntax-         CREATE DATABASE database_name ;

    Ex-                 CREATE DATABASE Employees ;

                                                     How to create a database in a Microsoft SQL server?

2- Create new Database using SQL Management Studio

    To create a new Database in SQL server management studio firs you open SQL Server Management Studio in your Computer then go to 'Object Explorer'.

I- In Object Explorer select your server name and explore it then you have find Database Folder then Right Click on Database folder and Select 'New Database'  option like as in following picture-

                                                                   How to create a database in a Microsoft SQL server?

II- After click on 'New Database' option a new window is appear on your Screen. Write your Database name as you have then click on 'OK'.

                                                             How to create a database in a Microsoft SQL server?

III- You have find your database in Database folder of Object Explorer.

                                                                              How to create a database in a Microsoft SQL server?