In this blog, I will show step by step how to create Database and Table to SQL Server. explain how its work and why we need to do this. Lets Go..

I. Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network.

To download MS SQL Server, click Here

II. Database

A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.

III. Database Table

A table is a collection of related data held in a table format within a database. It consists of columns and rows. In relational databases, and flat file databases, a table is a set of data elements using a model of vertical columns and horizontal rows, the cell being the unit where a row and column intersect.

IV. Requirements

  • Microsoft SQL Server

Download and Install SQL Server Management Studio to proceed with this tutorial.

V. Connect SQL Server

First connect the server, I’ll use my local DB and use windows Authentication. then Connect.

This is the view after connect is suceed.

VI. Create Database

  • look, currently this is my database, but we don’t use that. as what I said. We need to create Database and table in database.
  1. Right click the Databases, and click New Database.
  2. For the sick of the tutorial, I name this database as DB_Table_Tutorial. and click Ok to save the database.
  3. Now we have Database. so let proceed to Table.

VII. Create Table in Database.

  1. Open Database name and right click Tables and click Table to create Database table.
  2. fill out or list out all columns, in this tutorial I fill out id as primary key, username and password for user credentials. and name, age, email for other information of users. while we have TDT and UDT. TDT means Transaction Date Time or mostly used to when data created. UDT mean Update Date Time, used to indicate when data lastly updated.
  3. To set id as Auto Increment, see below settings and set identity specification (Is Identity) as 1 or Yes.
  4. to Save the Table. CTRL + S and for this tutorial I name this table as users. then OK.
  • now we have users table.

VIII. View data in table

  • Right click, users table and Click Select Top 1000 Rows to See TOP 1000 rows.
  • currently users table have one row of data. this is for sample purpose only.

Related Topics

5 Replies to “Create Database and Table in SQL Server”

  1. Youre so cool! I dont suppose Ive read anything like this before. So good to seek out someone with some original ideas on this subject. realy thank you for beginning this up. this website is one thing that is needed on the internet, somebody with a little originality. helpful job for bringing one thing new to the internet!

  2. Thank you, I have just been looking for info about this subject for a while and yours is the best I’ve came upon till now. But, what about the conclusion? Are you certain about the source?

Leave a Reply

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