Bug with SQL Server column default when dropping column

Toad Data Modeler
1

Hi,
I have generated an ALTER script which drops a column from a table in SQL Server 2008. The column has a default set in the “Default value or binding” column properties in SQL Server Management Studio.
When I run the ALTER script, I get an error that the column can’t be dropped because it is in use. I needed to add the following command manually in the ALTER script for it to succeed:
ALTER TABLE MyTable DROP CONSTRAINT DF_MyTable_MyField

The ALTER script was generated after a reverse engineering of the database.
Let me know if you need more information about this bug.

2

Hello,

Thanks a lot for your bug notification. We will fix it. CR # 67 911.

Thanks!

Regards,

Vladka + TDM Team

3

This is not fixed in version 3.14.16.7.

gabriel

4

Hi Gabriel,

Let me explain:
TDM 3.4.16 is developmentally lower version than BETA 3.5.x.
Therefore, the fix is not available in v. 3.4.16.

Nevertheless, you can test the fix in current BETA 3.5.3.1.
Please feel free to test it and let us know your feedback.
(The fix will be available in next commercial version 3.5.x.)

TDM commercial/trial and BETA can be both installed on your PC. BETA has its own location, config files etc. However, let me note that BETA is BETA. Also, we do not recommend to open and save your official models in BETA and reopen them in v. 3.4 that is developmentally lower.

If you have any questions, please write me back.
Thanks.

Regards,

Vladka

5

Thanks, I did not understand that the fix was planned for 3.5. I am not yet familiar with your release cycles. Sorry about that.

gabriel

6

No worries. Happy to explain. There are quite many releases (full v., patches, betas) and it’s becoming a little confusing.

Vladka