ITSourceCode.com

We Exist to Provide 100% Free Source Code and Tutorials

Custom Search

How to Create a Database in the SQL Server 2005

createSQLdbPI

In this tutorial, I will teach how to create a database in the SQL Server Management Studio Express (SSMSE) 2005SSMSE 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.

createSQLdbFig1

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

createSQLdbFig2

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

createSQLdbFig3

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

createSQLdbFig3.1

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

createSQLdbFig3.2

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

createSQLdbFig5.1

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

createSQLdbFig5

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

createSQLdbFig7

  • Finally, set the autoincrement of your primary key.

createSQLdbFig6

 

Facebook Comments

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked *

ITSourceCode.com © 2016 Frontier Theme

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!