Added Dependencies?

[scottyob]

G'Day all,

I've got a plugin for an application. When it's installed it runs the following:

Alter table DocketItem ADD Optimised BIT DEFAULT 0 NOT NULL

However, when the plugin is uninstalled it tries to run the following:

Alter table DocketItem DROP COLUMN Optimised

When the plugin is uninstalled, I get an error saying

The object 'DF__DocketIte__Optim__347EC10E' is dependent on column 'Optimised'.
ALTER TABLE DROP COLUMN Optimised failed because one or more objects access this column.

Would I be right in assuming that a dependency object was added to either satisfy the not null, or default values for this column? If so, could I create this object with a certain name (thus allowing the plugin to delete it?) or better yet, so something like I can in oracle, delete the column then 'cascade dependencies'?

Cheers,

Scotty