From the course: Learning SQL Server 2017

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a new database on the server

Create a new database on the server - SQL Server Tutorial

From the course: Learning SQL Server 2017

Start my 1-month free trial

Create a new database on the server

“

- [Instructor] Installing an example database is a good start, but what you probably want to know is how to create a database for your own personal projects or organization. Creating databases in SQL Server Management Studio is pretty straightforward. We first need to find the databases node inside of our server instance in Object Explorer. Then I'll right click on it and choose new database. On this window, we have a page for general items which is what we're seeing now. We also have a page for options and a page for file groups. We're going to focus on the general page. At the top of the general items page is an area where we can type in the name of the database that we want to create. In this case, I'm just going to name mine MyDatabase. On the bottom in this database file section, you might have noticed some activity taking place as we type in the name so let's go ahead and take a look at what just happened. Our database is going to be comprised of two separate files on our hard…

Contents