You are here:About>Computing & Technology>Databases> SQL Server> Creating Tables in Microsoft SQL Server
About.comDatabases
Suggested Reading

SQL Server Data Types

Creating Tables in Microsoft SQL Server

From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Design Your Table

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.
  1. Design Your Table
  2. Start SQL Server Management Studio
  3. Expand the Tables Folder for the Appropriate Database
  4. Start Table Designer
  5. Add Columns to Your Table
  6. Select a Primary Key
  7. Save Your New Table

Previous | Next >>

 All Topics | Email Article | Print this Page | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.