This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I think there is a bug in removing associations in the designer. Then updating the database It cant do it. Perhaps you are trying to remove the foriegn key before removing the association?
|
|
|
|
|
Could you let us know which database you are using? Thanks! |
|
|
|
|
I am using MS SQL The error is to the effect: cannot drop column 'blahbalh' it is tied to foriegn key 'FK_blah' |
|
|
|
|
SQL Server doesn't support "cascade constraints" so we previously haven't supported deleting associations on SQL Server (and should have displayed a message to this effect). However, we thought it was about time we got rid of this limitation! So this is now fixed and will be included in nightly builds dated 10 Dec 2008 and above. We did encounter a couple of quirks along the way to do with the non-FK constraints that may appear on columns (e.g. defaults). We've dealt with the cases that we've seen in our test databases but if you see other types of constraint that prevent the column being dropped then please let us know (if this happens, we would need to know the type of constraint, or failing that the name of the constraint (from which we can probably work out the type), and if you could provide us with the CREATE script for the table, that would be very handy). |
|
|
|
