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.