InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:46:36 GMT20http://www.sqlservercentral.com/Forums/Topic597917-145-1.aspxYou would need to drop the Foreign Keys then re-add them after you make the change.Thu, 06 Nov 2008 10:45:48 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic597917-145-1.aspxHi,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_USERS2.JV_RIGHTSNow 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.Wed, 05 Nov 2008 23:32:38 GMTavinash repe