go to design view and select data type as int now u will get properties there u need to put isidentityspecification make it yes and set seed value and increment value
Or by query use it
ALTER TABLE table-Name
{
ADD COLUMN column-definition |
ADD CONSTRAINT clause |
DROP { PRIMARY KEY | FOREIGN KEY constraint-name | UNIQUE
constraint-name | CHECK constraint-name | CONSTRAINT constraint-name }
ALTER column-alteration |
LOCKSIZE { ROW | TABLE }
}
column-definition:
Simple-column-Name DataType
[ Column-Level-Constraint ]*
[ [ WITH ] DEFAULT {ConstantExpression | NULL } ]
column-alteration:
column-Name SET DATA TYPE VARCHAR(integer) |
column-name SET INCREMENT BY integer-constant