Finding all the identity columns and the last inserted values in your Database February 19, 2012February 19, 2012 SELECT IC.NAME AS COLUMNAME,ST.NAME AS TABLENAME,IC.SEED_VALUE,IC.INCREMENT_VALUE,IC.LAST_VALUE FROM SYS.IDENTITY_COLUMNS IC INNER JOIN SYS.TABLES ST ON ST.OBJECT_ID = IC.OBJECT_ID WHERE IC.IS_IDENTITY = 1 AdvertisementShare this:TwitterFacebookLike this:Like Loading... Related
One thought on “Finding all the identity columns and the last inserted values in your Database”
I blog frequently and I seriously thank you for your content.
The article has really peaked my interest. I will bookmark your site and keep checking for new details
about once per week. I opted in for your Feed too.