Home Forums SQL Server 2005 SS2K5 Replication Remove a column in an article from Replication without reinitializing the replication RE: Remove a column in an article from Replication without reinitializing the replication

  • June 5, 2013 at 8:19 pm

    #1621579

    You do not need to remove an article to drop a column. Dropping a column does not require reinitialization either. You do not need to generate a new snapshot and you do not need to reinitialize subscribers. Make sure publication property @replicate_ddl is set to true.

    Per Make Schema Changes on Publication Databases in BOL:

    To drop a column from an existing publication and drop the column from the table at the Publisher, execute ALTER TABLE <Table> DROP <Column>. By default, the column is then dropped from the table at all Subscribers.