Sql-server – SQL 2005 Replication Create/Delete Tables, Views, and Procs

That link is for logread.exe. Checking the page for the stored procedure, see:

http://msdn.microsoft.com/en-us/library/ms190313%28v=SQL.100%29.aspx

I'm wondering if the hyphen is needed, as it is not listed like that on the stored procedure's page.

You can change the properties of the article (or of all the articles) when you create the publication. You can also change this after the fact by editing the publication. You can setup the replication to drop the tables (the default), truncate the data, delete the data, or do nothing. IF you need to load the data on the subscriber from scratch you'll need to setup the articles to delete the data. This means it will take a lot longer to apply the snapshot. It would be best to make sure that all the foreign keys exist in the publisher so that the publisher knows in what order to drop and recreate the tables on the subscriber.