Alter Column

[TomBarrand]

I am trying to change the datatype of a column using the following syntax:

ALTER TABLE Purch_Ord_Line
ALTER COLUMN Items_Per_Container int
Go
I get the following error:

Server: Msg 5074, Level 16, State 1, Line 3
The object 'DF_Purch_Ord_Line_Items_Per_Container' is dependent on column 'Items_Per_Container'.
Server: Msg 4922, Level 16, State 1, Line 3
ALTER TABLE ALTER COLUMN Items_Per_Container failed because one or more objects access this column.

What does this mean?

Cheers

 

[JohnDTampaBay]

It appears that there is a DEFAULT constraint on the column you are attempting to ALTER. You'll need to drop the constraint before you can alter the column.

Use

sp_help Purch_Ord_Line

to determine what the default value is. After altering the column type, you can recreate the appropriate default constraint.

Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.