Changing the data type of column from varchar to int

• na1774

  SSCrazy

  Points: 2301

  More actions

  August 2, 2012 at 6:00 pm

  #392883

  Hi All,

  I have a column which is a primary key. It was mistakenly made NCHAR which actually shoud have been int. Now I am trying to change the data type by using the alter table command I get the following errror

  Msg 5074, Level 16, State 1, Line 2

  The object 'PK_INK_NEXT_OPERATION' is dependent on column 'operation_id'.

  Msg 4922, Level 16, State 9, Line 2

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

  Shoud I drop the primary key make the change and then re create the Primary key??

• SomewhereSomehow

  SSCommitted

  Points: 1586

  More actions

  August 2, 2012 at 11:15 pm

  #1521229

  Yes, smth like this:

  alter table MyTable drop constraint PK_INK_NEXT_OPERATION;

  alter table MyTable alter column operation_id int not null

  alter table MyTable add constraint PK_INK_NEXT_OPERATION primary key (operation_id);

  ---

  I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
  Blog: http://somewheresomehow.ru[/url]
  Twitter: @SomewereSomehow