dropping a constraint

I think the answer to this question will be something like 'you'll have to re-initialize the subscribers', but I need to ask anyway...

I created a publication where my foreign key constraint we NOT created with NOT FOR REPLICATION. My publication is configured to replicate DDL changes. Is there any way I can drop and re-create the constraint in the publisher and get replication to push the change to the subscribers?

Thanks for your help

Graham

Graham,

You can use sp_addscriptexec to post a SQL script to all subscribers of your publication with all the constraint changes you want to make.

http://msdn2.microsoft.com/en-us/library/ms147904.aspx

http://msdn2.microsoft.com/en-us/library/ms174360.aspx

Regards,

Gary