Tutorials » SqlServer tutorials »

how to create a new database using Management Studio

This chapter explains how to create the SQL Management Studio to create a new database.

In previous chapters, you learned to how to connect to SQL Server 2005 using management studio. In this chapter, you will learn how to create and delete a database.

Create new database

To create a new database, right click on the "Databases" node in the left panel in the Management studio. You will get couple of options in the context menu. Select the option 'New Database'.

You will get another dialog box where you have to specify few details. The most important one is the database name. In the below screenshot, I have specified the new database name as "MySampleDatabase".

You may notice two other circled fields called "logical name" and "path". When any database is created, there is at least 2 files created in the hard disk. One file is called "Data file" and it has an extension of .MDF. The other file is called "log file" and it has an extension of .LDF by default. The logical names are the internal names used by the SQL Server to represent the data file and logical file. The path represents the physical location of the above files in your hard disk. The default location will be within the Program Files folder. You may change it to your projects folder or any other folder you want. However, the only mandatory entry required fill to create a new database is the database name.

Previous Chapter: Manage the Databases
More Chapters: Sql Server Tutorials
More Tutorials: Tutorial Index

Top Contributors
TodayLast 7 Daysmore...

Awards & Gifts

Online Members

Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India