Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disable foreign constraint Expand / Collapse
Author
Message
Posted Wednesday, November 5, 2008 11:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 14, 2009 8:49 AM
Points: 42, Visits: 99
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.
Post #597917
Posted Thursday, November 6, 2008 10:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:42 PM
Points: 10,193, Visits: 13,120
You would need to drop the Foreign Keys then re-add them after you make the change.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #598379
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse