Search This Blog

Friday, January 28, 2011

How to identify Indentiy column in a table and also max value for that Identity column


DBCC checkident (tablename)Eg:

create table b (i int identity ,n int)

 insert into b
select 122
union
select 135

select * from b 


 dbcc checkident(b)

No comments:

Post a Comment