I have a product table which has 10 million data.
when i try to drop a fk constraint on this table, its taking long time but no success commet.
Please provide a solution
ALTER TABLE YourTableName
NOCHECK CONSTRAINT YourFKConstraintName
Then try to drop the FK constraint. It should be faster.
If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?