How to remove all publications for database

Use this code:

-- Remove replication objects from the subscription database on MYSUB.
DECLARE @subscriptionDB AS sysname
SET @subscriptionDB = N'AdventureWorks2008R2Replica'

-- Remove replication objects from a subscription database (if necessary).
USE master
EXEC sp_removedbreplication @subscriptionDB
GO

Source:http://technet.microsoft.com/en-us/library/ms188734.aspx


Also related:
http://technet.microsoft.com/en-us/library/ms147833.aspx

To delete a snapshot or transactional publication

1. Do one of the following:

   • To delete a single publication, execute sp_droppublication at the Publisher on the publication database.

   • To delete all publications in and remove all replication objects from a published database, execute sp_removedbreplication at the Publisher. Specify a value of tran for @type. (Optional) If the Distributor cannot be accessed or if the status of the database is suspect or offline, specify a value of 1 for @force. (Optional) Specify the name of the database for @dbname if sp_removedbreplication is not executed on the publication database.

     Note
     Specifying a value of 1 for @force may leave replication-related publishing objects in the database.

2. (Optional) If this database has no other publications, execute sp_replicationdboption (Transact-SQL) to disable publication of the current database using snapshot or transactional replication.

3. (Optional) At the Subscriber on the subscription database, execute sp_subscription_cleanup to remove any remaining replication metadata in the subscription database.