Unbinding Objects from a Replication Path

Use the unbind parameter with sp_replication_path to remove the association between a bound object and a physical or logical replication path.

To remove the binding between an object and one or more primary replication paths, enter:

sp_replication_path dbname, 'unbind', "object_type", "object_name", {"path_name"|all}

where:

object_type – specifies the type of object that can be either path, table, or sproc (stored procedure).
[table_owner.]object_name – name of the table, stored procedure, or path that you want to unbind.
Note: If you do not specify a table owner if the object is a table, the binding applies only to tables owned by dbo, the database owner.
path_name | all – specifies a physical or logical path name, or all paths. If you specify path as the object_type, provide the path name as object_name, and specify the all option, Replication Agent unbinds all objects from the path name you specified.

For example:

To remove the binding t1 table from the pdb_2 replication path:
```
sp_replication_path pdb, 'unbind', "table", "t1", "pdb_2"
```

To remove all bindings on the t1 table:

sp_replication_path pdb, 'unbind', "table", "t1", "all"

To remove the binding of all objects to the pdb_2 replication path:
```
sp_replication_path pdb, 'unbind', 'path', 'pdb_2', "all"
```