creating a database in sql server

Creating a database in Sql Server

SQL Server is a more popular and large database. The SQL server is used to store large relational data. The database in SQL Server means that you can store large relational data in SQL Server. To store the large relational data in SQL Server, the user must create a database in SQL Server.

Creating a database in SQL Server: the user can create a database in SQL Server in two ways. One of them is using the SQL query instruction and another is using the graphical user interface of measurement by clicking with the mouse.

Creating a database in Sql Server using Sql query statement: 

Syntax: Create database Database-Name

Description: 

Create Database: Create Database is Sql Statement which is used for creating database in Sql Server.

Database-Name: It means database name as user choice.

Example: 

Create Database EmployeeDetails
Create Database ProductDetails
Create Database Student
Create Database ItemDetails
Create Database BookDetails
Create Database WorldBank
Create Database CaliforniaBank
Create Database WTO
Create Database UNESCO
Create Database NASSA
Create Database UN
Create Database Chemical
Create Database WorldLibrary
Create Database Customer
Create Database IMF
Create Database Sales

So on..

Creating Database in Sql Server steps

1. Select Database name. Like in image
2. Click on Execute Option. Like Image
          OR
Press F5 key on keyboard

--After pressing Execute Option you will get successful message like in image.

Creating databa in sql server steps image:

Changing database name. Look at following image:

OR

You can change sql server database name using sql statement.

Syntax:

            Use DATABASE-NAME

Exmaple:

              Use ItemDetails

Look at following picture to change database name in SQL server using sql statement:

1. Type the text: Use ItemDetails (Like on image)

2. Select the text. (Like image)

3. Click on Execute Option. (Like Image)

--Database name is changed in sql server like in image--