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