How SQL Server manually sets the automatic growth of the ID value (primary key)

Source: Internet
Author: User

Recently, I have used the operation of SQL Server database to do something. Well, really long time did not see, to this database is unfamiliar to the pole, even the simplest how to set an ID primary key, let it with the insertion of data, automatic growth ID value settings are forgotten, online check a bit, many people say the use of code, like I want to be different, and then Baidu know found the answer, Although a little embarrassed, but still stick it out:

Q: How do I manually set the SQL Server ID (primary key) so that it grows automatically as the data is inserted?

A: Click on the table you want to set, right-click-Design--In the column, click below the id--appears below the figure:

Self-increment definition:

Then click OK to!!!!!!!

How SQL Server manually sets the automatic growth of the ID value (primary key)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.