SQL server set identity max value -


i want create column identity property , want specify max value.

for example:

create table tbl (   id int primary key identity(1,1) ) 

i want specify 20000 max value id.

alter table tbl add constraint chk_tbl_max_id check (id <= 2000) 

example @ sql fiddle.


Comments