Cannot drop the table <TableName> because it is being used for replication

13,118

As the error says the table is used for replication, meaning it's an article in a replication publisher. To be able to modify the table you should remove it from replication, then update the schema, afterwards add it again in the replication. After adding it again you will have to reinitialize the subscriptions to pick up the modified table schema.

Share:
13,118
pramod maurya
Author by

pramod maurya

Updated on September 01, 2022

Comments

  • pramod maurya
    pramod maurya over 1 year

    I am unable to modify the structure of a table in a database. database used for replication. I am getting This error

    enter image description here

  • pramod maurya
    pramod maurya about 8 years
    my database replicate from more then 30 clients so if there is any other option that i can try?