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

  • To drop a column from an existing publication you'll need to use ALTER TABLE <Table> DROP <Column> syntax at the publisher. By default the schema change will be propogated to subscribers on the next synchronization, publication property @replicate_ddl must be set to true. Reinitialization is not required.

    There are some considerations to make which can be found in Making Schema Changes on Publication Databases.