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
Post a Comment