Tuesday, 13 August 2013

Change length of column of table which have dependencies

Change length of column of table which have dependencies

I've got a table named Contacts with column Title varchar(50) . Now in the
middle of development I want to change the length to varchar(100) of field
Title .At the moment table Contacts has over 25 dependencies (other
tables, views functions). When I run following sql statement in sql server
2008 . I am getting errors.
ALTER TABLE [Contacts ] ALTER COLUMN [Title ] varchar(100)
Error Like
Msg 5074, Level 16, State 1, Line 2
The object 'Contacts_title' is dependent on column 'title'.
And more.

No comments:

Post a Comment