Alison Balter's Mastering Access 2002 Enterprise Development

Creating SQL Server Tables

Tables in a SQL Server database are similar to tables in Microsoft Access. Each table is made up of rows and columns. As with Access, we refer to columns as fields. Each field has a unique name and contains a specific piece of information about the row. Each table in a SQL Server database must have a unique name.

To create a table:

1.	Within Enterprise Manager, right-click the Tables node of the database to which you want to add a table and select New Table. The Table Designer appears (see Figure 5.1). Figure 5.1. The Table Designer allows you to enter the column names, data types, length, and other properties for each field in the table. [View full size image]
2.	Enter the column names, data types, and length for each ...