locked
FK Constraint RRS feed

  • Question

  • When defining FK, what is ment by Not for Replication? Does it mean that the table FK is created on is Not going to be replicated from  or to?

    Friday, September 23, 2011 4:14 PM

Answers

  • The NOT FOR REPLICATION option means that the constraint is enforced on on the publisher.  There is often no need to enforce the constraint on the subscriber too since referencial integrity has already been validated on the publisher.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    Saturday, September 24, 2011 3:12 AM
    Answerer

All replies

  • The NOT FOR REPLICATION option means that the constraint is enforced on on the publisher.  There is often no need to enforce the constraint on the subscriber too since referencial integrity has already been validated on the publisher.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    Saturday, September 24, 2011 3:12 AM
    Answerer
  • The NOT FOR REPLICATION option means that the constraint is enforced on on the publisher. There is often no need to enforce the constraint on the subscriber too since referencial integrity has already been validated on the publisher.

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    Saturday, September 24, 2011 3:13 AM
    Answerer