Why am I unable to update the column identity specification?

Question

1.00/5 (1 vote)

See more:

I have created a table which has one column name 'Status" with the data type = char (10). Now I am trying to update the Status Column Identity Specication so that I can see Status Column = Active/Inactive or Yes/NO or True/False. But I see the Column Properties are gray out. I am unable to change the Status Column Identity Specification.

What I have tried:

I have set up PK to UserID, changed the data type from Char(10) to bit, varchar (10) and again char(10). did not work.

Posted 10-Mar-21 17:31pm

Member 15093506

Updated 10-Mar-21 21:55pm

Add a Solution

Comments

CHill60 11-Mar-21 3:20am

What is UserID????? Show us the code you used to create the table. If you did it in SSMS then use the right click, script table as create to clipboard

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2021-03-10T21:55:00

Solution 1

The IDENTITY property[^] can only be used with integer columns (smallint, int, or bigint). You cannot use it with a char or varchar column, nor with bit columns.

Posted 10-Mar-21 21:55pm

Richard Deeming

Why am I unable to update the column identity specification?

1 solution

Solution 1

Add your solution here

Preview 0

Why am I unable to update the column identity specification?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us