Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication Drop table

Status
Not open for further replies.

wminghao

Programmer
May 29, 2000
24
US
Hi,

I created a merge replication for two databases. I would like to drop a table(article) now. But it seems do not allow me to do so.

I also checked the stored procedures where I can only find sp_repladdcolumn and sp_repldropcolumn, but not how to drop tables, does anyone have any ideas???

One stupid way is recreate the replication publication. I don't want to do that because if affects my data integrity.

Sincerely
wminghao
 
Hi,

If you remove the subscriptions from the publication I believe this allows you to delete the table, though I'm not 100% sure.

Thanks,

Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top