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