Breaking database replication
Delete publications from the Local Publications folder in Microsoft SQL Server Management Studio.

To delete a publication



1.Connect to the Publisher in Management Studio, and then expand the server node.

2.Expand the Replication folder, and then expand the Local Publications folder.

3.Right-click the publication you want to delete, and then click Delete.