1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Creating Tables in Microsoft SQL Server

By

5 of 7

Add Columns to Your Table
Creating Tables in Microsoft SQL Server

Creating Table Columns

Mike Chapple
Now it's time to add the columns you designed in step 1. Begin by clicking in the first empty cell under the Column Name heading in Table Designer.

Once you've entered an appropriate name, select the data type from the drop-down box in the next column. If you're using a data type that allows different lengths, you may specify the exact length by changing the value that appears in parentheses following the data type name.

If you'd like to allow NULL values in this column, click "Allow Nulls".

Repeat this process until you've added all necessary columns to your SQL Server database table.
Related Video
Add Sound to PowerPoint
  1. About.com
  2. Technology
  3. Databases
  4. SQL Server
  5. Add Columns to Your Database Table

©2014 About.com. All rights reserved.