Replication - Dropping a Table

I'm new to replication and would like to know how to drop an article published for replication. I believe I need to follow these steps, but I am unsure.

Step (1)
exec sp_dropsubscription @publication = N'db name',
@article = N'article name',
@subscriber = 'subscriber name',
@destination_db = N'db name'

Step (2)
exec sp_droparticle @publication = N'db name',
@article = N'article name'

Step (3)
drop the article on the publisher

Step (4)
drop the article on the subscriber

Is this the correct sequence or am I missing something.

Thanks, Dave

Note: Snapshot and transactional replication

If you drop the subscription on an article in an immediate-sync publication, you cannot add it back unless you drop the subscriptions on all the articles in the publication and add them all back at once.

An article cannot be removed if one or more subscriptions exist.

remove article from the subscriptions first and then remove the article from publisher

Basically it will not allow you to remove the article from the publisher if you have a subscriber.


I hope this helps

Thanks,
Anu

Thanks. I'll give it a try.

Dave