sql server 2008 r2 - I can't view the primary key on my table -



sql server 2008 r2 - I can't view the primary key on my table -

i'm new sql server (i'm learning sql server 2008), have question:

i have database "two trees test" 2 tables in (employee & product), design of employee table:

employeeid int not null (primary key) firstname nvarchar(50) not null lastname nvarchar(50) not null title nvarchar(50) not null hiredate date null birthdate date null phone nvarchar(20) null status bit not null

you can see have primary key (employeeid), if go edit view (so can start insert data), can't see primary key.

thanks in advance help & apologies if misspelled (english isn't first language), tried attach screenshots can't because don't have 10 points yet.

maybe primary key auto-increment might not allow come in value it.

see this give custom values primary column.

sql-server-2008-r2 primary-key

Comments

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

django - Access session in user model .save() -

php - .htaccess Multiple Rewrite Rules / Prioritizing -