Creating A Database Using Microsoft SQL Server Management Studio 2008 R2 For Beginners

Creating A Database Using Microsoft SQL Server Management Studio 2008 R2 For Beginners

Basically you need to understand first what a database is. Consider it as a container which stores all the information and various objects such as tables, views, stored procedures etc. The 4 predefined system databases in our server are master, model, msdb, and tempdb. But after the installation of the SQL Server in our system we can even create our own databases to hold the programs and information.

1. Open the Microsoft SQL Server Management Studio and connect it to a Database engine. The Server Name field allows you to specify the SQL Server Instance. This instance will contain and manage your databases. Since we are not connecting to a server so it’s favorable to use Windows Authentication to login your local information. Then connect to the database engine to continue.

2. Now use the object explorer and expand the Database folder to see a System Database folder. All the created databases will appear in this folder and we shall be able to modify them later as per our requirements.

3. Now we will be creating the database by clicking on the New Query to open a window. We will use the Create Database statement then specify the database name and finally execute the query.

In above picture see how I called the CREATE DATABASE statement and had specified the database name sports.
4. Now using the object explorer we can see that a database is created with the name SPORTS in a single query. We can even create tables in them and then later on, add the required data to make them more organized which was not possible in SQL Server Compact.