I have everything generated for database table. And now i want to remove one of the key field from table and make it normal field. How this could be achieved? Just removing it from table gives me an error as,
Old key field AGENCY_ID is now non-key field ( Alter table not possible).