I have master table JV_PROFILE with profile_id char(1) primary and non clustered index.
Profile_id column is refered as foreign key constraint in two other tables -
Now i want to change data type of profile_id colmun from char(2) to int. but it did not allow as index and foregin kay constraint.
I have tried disble primary key index but still it did not allow.
Please suggest solution.
Thanks in advance.