• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Changing Indentity Specification

For my primary key in a table, I need to change the Identity Specification to Yes, Identity Increment to 1 and Identity Seed to 1.  I'm trying to type in field but its not accepting it (acting like its locked).  How do I modify these properties?
ee-identityspecification.jpg
0
gcgcit
Asked:
gcgcit
  • 2
  • 2
1 Solution
 
kamindaCommented:
You should first set Identity Specification to YES then other fields get activated after that.
0
 
knightEknightCommented:
Is there already data in this table?
0
 
kamindaCommented:
Sorry I think I have mis read your question, Are you trying to do this for an Existing column then it is not possible

You can't alter the existing columns for identity.

You have 2 options,

1. Create a new table with identity & drop the existing table

2. Create a new column with identity & drop the existing column
0
 
knightEknightCommented:
... after step 2 above you can re-name the new column back to it's original name.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now