Hi Mona,
I'm afraid I cannot mark that as the answer.
Deleting an Entity is not an acceptable solution. In development it's not that big a deal, but if this were in production with several thousand or not so uncommon, over a million entries, this would be a major issue.
So far I've had to delete entities on several occasions because there was no alternative to solving the issue.
Something simple as a field type change should not prevent you from changing the type or even worse prevent you from deleting the field itself, which is why I resorted to deleting the entire Entity. There was no data in the Entity and no related Entities so there should not have been any conflicts.
I like the concept of the CDS and I'm sure it will get better as time goes on, but at this time given the issues I've experienced and that there are no real troubleshooting tools available, no access to log files etc..., the only troubleshooting help we have are the error messages, which as I've said before are confusing and of no help.
The CDS is not suitable for my purposes at this time.
Thank you for your help.
Regards,
Keith