How do I create a local database inside of Microsoft SQL Server 2014?

sql-server database sql-server-2014
user3123222 picture user3123222 · May 29, 2015 · Viewed 137.6k times · Source

Forgive me if this question was already asked before.

I just installed Microsoft SQL Server Management Studio 2014. I want to create a database so I can start building some tables from scratch. All I am getting is the ability to connect to a database. Not create a new database.

Answer

Christian Barron picture Christian Barron · May 29, 2015

As per comments, First you need to install an instance of SQL Server if you don't already have one - https://msdn.microsoft.com/en-us/library/ms143219.aspx

Once this is installed you must connect to this instance (server) and then you can create a database here - https://msdn.microsoft.com/en-US/library/ms186312.aspx

Related questions

SQL create database if not exists, unexpected behaviour

I have a long stored procedure which begins with the following statement: IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = N'DBNAME') BEGIN CREATE DATABASE [DBNAME] END; It is expected to create the DB on my local server, if it …

Read More
How to insert values into two tables with a foreign key relationship?

I created two tables: Table tblStaff with columns id (primary key, auto increment), name, age, address Table tblRoleOfStaff with columns id (primary key, auto increment), StaffId (foreign key to tblStaff), RoleId I have form to create new staff with existing …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More