Creating Tables in Microsoft SQL Server

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.