im creating this table;
create table employee_tbl
(
emp_id varchar(9) not null,
last_name varchar(15) not null,
first_name varchar(15) not null,
middle_name varchar(15),
address varchar(30) not null,
city varchar(15) not null,
state char(2) not null,
zip number(5) not null,
phone char(10),
pager char(10),
constraint emp_pk primary key (emp_id);
its taken from a book that uses an oracle sql syntax. im altering it to sql server 2000 syntax. originally the varchar was varchar2 so i changed that. i got stuck on the primary key bit. does that make sence?