How to apply schema changes on publication databases (Enterprise Manager)

How to Install SQL Server 2000

How To

How to apply schema changes on publication databases (Enterprise Manager)

To add columns to an article

  1. In SQL Server Enterprise Manager, under Replication, expand Publications and then right-click the publication where you want to modify a schema.

  2. Click Properties, click Filter Columns, and then click Add Column.

  3. In the Add Column to Replicated Table dialog box, enter the name of the column and the SQL syntax that defines the column. In the SQL for the column definition, you must either specify a default value or allow NULL values.

  4. For information about the syntax required to define the column, see the Transact-SQL ALTER TABLE statement.

  5. In the Add Column to Replicated Table dialog box, select the publications to which you want to add the column.

To drop columns from an article

  1. In SQL Server Enterprise Manager, expand Replication, expand Publications, and then right-click the publication where you want to modify a schema.

  2. Click Properties, click Filter Columns, select a table in the Tables in publication list, select a column in the Columns in selected table list, and then click Drop Column.

  3. If the column is constrained, you will be prompted; columns with primary key or unique constraints, and uniqueidentifier columns cannot be dropped. If you attempt to drop one of those types of columns, an error message is displayed. For other constraints, a warning message is displayed; click OK to drop the column.