Drop a column for MS SQL Server database (not express)

[expired user #9806]'s profile image [expired user #9806] posted 7 years ago in General Permalink

I created the table and populated it via HeidiSQL 8.3 I realized the last column named ImageChanged, type TINYINT, belonged in a different table. When I tried to remove the column I saw: SQL Error (4922): The object 'DF_QR_ImageChanged_2027B809' is dependent on column 'ImageChanged'

I presume object DF_QR_Image... was created behind the scenes when HeidiSQL created the column. I suppose I need to remove that object before I can remove the column. But how do I do that?

Thank you,

Please login to leave a reply, or register at first.