Increase column length in SQL 2000

• tome-473314

  Old Hand

  Points: 309

  More actions

  August 3, 2007 at 12:59 pm

  #125261

  I am trying to increase a column length from char(5) to char(10) using

  ALTER TABLE [dbo].[tablename] ALTER COLUMN [colname] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

  It gives me error ... ALTER COLUMN failed because one or more objects access this column

  There are some indexes and views that reference this col. Do I need to drop and re-create the indexes and views? Is that the only way. The view is created using 'WITH SCHEMABINDING'.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 3, 2007 at 1:02 pm

  #724619

  Yes.

   

  This is one rare case where using EM to do the job will be faster... and error proof (developping time wise).