Hope this helps...!

http://msdn.microsoft.com/en-us/library/ms147921.aspx

use [$(PublisherDatabase)]

--Drop all subscriptions

exec sp_dropsubscription

@publication = N'TestPubs',

@article = N'all',

--@subscriber = [$(SubscriberServer)]

@subscriber = N'all',

@destination_db = N'all'

--Drop publication

if exists (Select 1 From SysPublications where name = N'TestPubs')

EXEC sp_droppublication @publication = N'TestPubs'

EXEC sp_replicationdboption @dbname = [$(PublisherDatabase)], @optname = N'publish', @value = N'false'

--Drop subscriber entry

EXEC sp_dropsubscriber @subscriber = [$(SubscriberServer)]

--Drop distributor

EXEC sp_dropdistributor @no_checks = 1