How to Create a Database in the SQL Server 2005

In this tutorial, I will teach how to create a database in the SQL Server Management Studio Express (SSMSE) 2005. SSMSE has a visual appearance to lessen the difficulty and simplifies the database management.

Pre-requisite

You need to install the following:

SQL Server 2005 Express Edition

SQL Server 2005 Management Studio Express Edition

Let’s begin:

• Open the Microsoft SQL Management Studio Express. For the authentication, choose Windows Authentication and hit the connect button.

• Right click the folder named “database” and hit “New database” to create a new database.

• A “New Database” window will appear. Put a database name according to your desire and then hit “ok” button.

• The database that you have created will appear in the object explorer under the “database” folder.

• In creating a table, select the database that you have created. After that, right click the folder named table then, hit “New Table“.

• Then, this will be the appearance as shown below.

• Create a column and change the table name according to your desire.

• Right click the column(ID) and hit “primary key” with a key symbol to set a primary key.

• Finally, set the autoincrement of your primary key.