Assigning the Maximum value for an Identity Column in SQL Server

When an identity is created for a column in a table in the database, it is possible to assign the minimum and maximum values for the identity column in the table.

Let’s assume that, we need a column that starts with 2000000000 with an increment of 1 and the maximum value for this identity column should be 7999999999. Below is the query that satisfies our requirement.

ALTER TABLE TEST_IDENTITY add ID INT identity(2000000000,1) CHECK (ID <= 7999999999)    

Hope this will be helpful!!

Leave a comment


  1. Excellent website. Lots of helpful info here. I am sending itt to some pals ans also
    sharing in delicious. And naturally, thank you for your effort!

  2. I just like the helpful info you supply to your articles.

    I will bookmark your blog and take a look at once more right here regularly.
    I’m fairly sure I’ll be informed plenty of new stuff proper right here!
    Best of luck for the next!

  3. You produced a handful of outstanding points throughout ur blog
    post, “Assigning the Maximum value for an Identity Column in SQL Server | Suneetha’s Blog”. I may end up coming back again to your web site soon. Thank you -Michael

  4. I absolutely love your blog and find a lot of your post’s to be precisely what I’m looking for.

    Do you offer guest writers to write content for you personally?
    I wouldn’t mind writing a post or elaborating on a lot of the subjects you write concerning here. Again, awesome web log!

  5. Admiring the persistence you put into your site and in depth information you provide. It’s good to come across a blog every once in a while that isn’t the same outdated rehashed information. Wonderful read! I’ve bookmarked your site and I’m including your RSS feeds to my Google account.
    My website is [url=]educational toys for toddlers[/url].

  6. Love your blog!

  7. Love your blog!

  8. Great post!

  9. A very impressive article. Well prepared. Very motivating!! Go off on to facilitate way

  10. An excellent post, providing something good to read,it’s just good to came across the post on hand sets and its features.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

  • Recent Posts

    • 450,719 hits
  • Join 37 other followers

  • Archives

  • Categories

  • November 2011
    M T W T F S S
    « Sep   Dec »
  • Advertisements
%d bloggers like this: