Click here to Skip to main content
15,569,644 members
Please Sign up or sign in to vote.
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.
Updated 10-Mar-21 22:55pm
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

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.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900