Hi Jess,

Looks like you've DEFAULT constraint on that column. You've to drop it before you can delete the column.

>What does it mean if I have this kind of error:
>

"Connectivity error: [Microsoft][ODBC SQL Server Driver]
>[SQL Server]The object 'DF_Items_saleprice' is dependent on
>column 'saleprice'?

>I was just trying to delete said column using SPT instead of doing it using Table Designer. BTW, I am using SQL Server 2000.