We
can create database in two different ways. In this Article I will explain both method
to create database.
1.
Using SQL command:
Syntax: Create database DataBase_Name
Example: Create database Test
When we execute this
statement, database “Test” will be
created. To use this database either select Database name like given below:
Or Use sql query
use Test
2.
Other method
to create Database:
a) Open sql
server management studio. Then connect
to the server you want to connect by using credentials. Now expand Object explorer
tree if not expanded.
Then right
click on Database folder and Select
“New database”:
b) New popup
window will be appearing. Now Enter database name
and press ok button. New database
will be created.
Now
u can use this database and create table or stored proc in this database.