Next, open the SQL Server Object Explorer screen. Now, remember that you made a database called People and then within it you have a table also called People. Further, within that you have a column called Id. This is the primary key. Remember, that it's auto-incremented so that you don't have to specify the ID. That is, it's done for you automatically.
Next, there are two fields: one is NAME, and the other one is DATEADDED; NAME is varchar(100) and DATEADDED is of type date. Both values have to be supplied, and that's why it says not null. The SQL Server Object Explorer screen up to this point is shown in Figure 18.3.2:
Figure 18.3.2: The SQL Server Object Explorer screen for the database People