How to create a database in a Microsoft SQL server also write query?
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 ;
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-
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'.
III- You have find your database in Database folder of Object Explorer.