top of page
Post: Blog2_Post
Search

How to create database in Microsoft SQL Server using SQL Statement

Here we will create database named Futzen in Microsoft SQL Server


Step1: Login into SQL Server using SQL Server Management Studio (SSMS) using required credentials


Step2: Use Master

go

--and press F5


Step3: CREATE DATABASE FUTZEN

ON PRIMARY

(NAME = N'futzen', FILENAME = N'c:\futzen.mdf' , SIZE = 1000KB , MAXSIZE = UNLIMITED)

LOG ON

( NAME = N'futzen_log', FILENAME = N'c:\futzen_log.ldf' , SIZE = 1000KB , MAXSIZE = 100GB)

WITH CATALOG_COLLATION = DATABASE_DEFAULT


and press F5 to create database


replace futzen with your database name


8 views0 comments

Recent Posts

See All

How to create cursors in microsoft sql server

-- how_to_use_cursors 2023,9 alter procedure how_to_use_cursors @year bigint, @month bigint as begin declare @employee_id bigint declare @No_of_days_present bigint declare @total_no_of_days bigint dec

bottom of page