Disable foreign constraint

• avinash repe

  Mr or Mrs. 500

  Points: 562

  More actions

  November 5, 2008 at 11:32 pm

  #99333

  Hi,

  I have master table JV_PROFILE with profile_id char(1) primary and non clustered index.

  Profile_id column is refered as foreign key constraint in two other tables -

  1.JV_USERS

  2.JV_RIGHTS

  Now i want to change data type of profile_id colmun from char(2) to int. but it did not allow as index and foregin kay constraint.

  I have tried disble primary key index but still it did not allow.

  Please suggest solution.

  Thanks in advance.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 6, 2008 at 10:45 am

  #895084

  You would need to drop the Foreign Keys then re-add them after you make the change.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question