Skip to Content
Dec 02, 2022 at 10:17 AM

Cant remove key field from original table as well as draft table

28 Views Last edit Dec 02, 2022 at 10:22 AM 2 rev

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).