Alter Table problem

• venkat-216866

  SSC Veteran

  Points: 257

  More actions

  April 27, 2006 at 7:19 am

  #117408

  I  have faced one problem. I tried to alter column to increase size of column. But I am getting following error. The column assessorabbr is not foreign key and not related to any table.

   My alter command is

   ALTER TABLE tblAssessor ALTER COLUMN AssessorAbbr VARCHAR(100)  NOT NULL

   Server: Msg 5074, Level 16, State 8, Line 1

  The statistics 'hind_63_9' is dependent on column 'AssessorAbbr'.

  Server: Msg 5074, Level 16, State 1, Line 1

  The statistics 'hind_62_9' is dependent on column 'AssessorAbbr'.

  Server: Msg 4922, Level 16, State 1, Line 1

  ALTER TABLE ALTER COLUMN AssessorAbbr failed because one or more objects access this column.

   

  Can any one help...to solve this... Thanks in advance

   

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  April 27, 2006 at 7:47 am

  #634570

  Drop the statistics  'AssessorAbbr' before altering the table and recreate the statistics after the alter. Hope this helps.

  Kind regards,

  Gift Peddie

  Kind regards,
  Gift Peddie