How to Alter / Drop Table after publication

Kail,
have a look at sp_repladdcolumn and sp_repldropcolumn.
There is no sp_replaltercolumn, although the 2 procedures
above can be used to achieve the same effect.
If your question is referring to changing or dropping a
table after a publication has been removed, then have a
look at sp_removedbreplication and sp_MSunmarkreplinfo.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Dear Paul,
Thanks for your help, it can be done now, thanks alot
Kail
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:181901c4bb30$ddef2c40$a301280a@.phx.gbl...
> Kail,
> have a look at sp_repladdcolumn and sp_repldropcolumn.
> There is no sp_replaltercolumn, although the 2 procedures
> above can be used to achieve the same effect.
> If your question is referring to changing or dropping a
> table after a publication has been removed, then have a
> look at sp_removedbreplication and sp_MSunmarkreplinfo.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
sql