Announcement

Collapse
No announcement yet.

Is it possible to make the autoincrement field type in the imported table?

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

  • Is it possible to make the autoincrement field type in the imported table?

    I use:
    - Win 7x64
    - MS Sql Server 2012
    - Navicat 12.0.17 (64-bit) - Premium.

    In MS Access, I have a table.
    In the tables, the fields "id" have auto-increment.
    I import tables from MS Access to ms Sql Server via Navicat.

    The tables I imported do not have auto-increment.
    I need to set the auto-increment through a special request for each table.

    Question.
    Is it possible to make the autoincrement field type in the imported table?

  • #2
    Please upgrade your Navicat Premium to latest version (choose Help > Check for Updates) and follow the steps below again:

    1. Open a table designer.
    2. Add an int, decimal or numeric field in the Fields tab.
    3. Select the Options tab, choose the new field in the Identity Field drop-down list.
    4. Set the Identity Seed, Identity Increment, Current Identity Value options if necessary.
    5. Save the settings.

    Comment

    Working...
    X