Add/drop colum in repl DB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Add/drop colum in repl DB

I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in production db do I need to do the same thing in repl db or do I need to rerun the snapshot agent?
You can use sp_repladdcolumn sp_repldropcolumn to add or drop columns to a previously replicated table. You can also modify this via the UI on the article properties page. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
If you add a new table to the publication, you will need rerun snapshot agent. WBR, Vlad A. Scherbinin
Rerun the snapshot but it does not replicate the new table.
Last action msg: A snapshot was not generated because no subscription needed the initialization
please refer the following in order to drop / add column to replicated db : Regards. hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

I wanted to know how do we replicate the new table from publisher to subscriber..
I know how to add/drop column…
so is there any way that i can replicate the new table without initialize the shema and data ?