Announcement

Collapse
No announcement yet.

How do I create an Auto Increment Field for MS SQL databases

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I create an Auto Increment Field for MS SQL databases

    I have Navicat Premium 12, and when I connect to a MS SQL database table, and go to the design mode, I can not find how to set an Auto Increment field.

    For MYSQL, there is an auto increment check box, but no such check box is available to MS SQL database tables that I can find.

    I found where you where supposed to set it using the Identity Field, and I found that in the Options tab, but choosing the field I want to be the auto increment field and pressing save doesn't seem to do anything.

    Thanks for any help.

  • #2
    We would like your assistance to identify the problem. Please provide the following information:

    1. Your Navicat version, e.g. Navicat Premium (Windows) 12.1.8 64-bit
    2. Your Server version, e.g. SQL Server 2014
    3. Screenshots showing settings on the Fields tab and the Options tab
    4. Screenshots showing how to reproduce the problem.

    Comment

    Working...
    X