SQL Server databases rely upon tables to store data. In this tutorial, we'll explore the process of designing and implementing a database table in Microsoft SQL Server.
The first step of implementing a SQL Server table is decidedly non-technical. Sit down with a pencil and paper and sketch out the design of your database. You'll want to ensure that you include appropriate fields for your business needs and select the correct data types to hold your data.
You may wish to consult our Database Normalization Basics article for some tips on proper database design.
Creating Tables in Microsoft SQL Server
By Mike Chapple, About.com
1 of 7
Prev Next
Design Your Table
Prev
- Design Your Table
- Start SQL Server Management Studio
- Expand the Tables Folder for the Appropriate Database
- Start Table Designer
- Add Columns to Your Table
- Select a Primary Key
- Save Your New Table
Suggested Reading
Suggested Reading
Explore Databases
Must Reads
About.com Special Features
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.