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

image

Then right click on databases and click on create database

image

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

image

Creating Database with Script

create database SQLDemo
Alter Database with script

USE master;
GO
ALTER DATABASE SQLDemo
Modify Name = SQLDemo2 ;
GO

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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