Identity field disbaled in SQL Server Enterprise Manager -

create table persons ( p_id int not null auto_increment, lastname varchar(255) not null, firstname varchar(255), address varchar(255), city varchar(255), primary key (p_id) ) 

i know above code making table in coding type, sql server enterprise manager doesn't support making tables or database in query mode

i have made database , tables using design view, when click on column of primary key identity/increment disabled? need system in vb

you using sql server microsoft, uses identity columns instead of auto_increment

create table persons ( p_id int not null identity, lastname varchar(255) not null, firstname varchar(255), address varchar(255), city varchar(255), primary key (p_id) ) 

if insist on using enterprise manager, can expand tree database\table. right click on table in list , choose "design table". when have column p_id chosen, @ bottom able drop down identity setting change "yes".