Creating SQL Server database with SSMS or SQL script

Here, we are going to learn how to create SQL server Database with script and SSMS

Create database with SSMS : Sql Server Management Studio

First we need to connect to SQL server with windows or sql authentication


Then right click on databases and click on create database


Then enter the database name and click on ok to create.

by default sql server will get the default storage location for sql db you are going to create. If you want to change you can do that as shown in the below picture


Creating Database with Script

create database SQLDemo
Alter Database with script

USE master;
Modify Name = SQLDemo2 ;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s