For example , execute alter table drop column at the publisher , and the statement is replicated to subscribers and then executed to drop the column 例如,在发布服务器上执行alter table . . . drop column ,该语句将复制到订阅服务器,然后执行以删除列。
Modifies a table definition by altering , adding , or dropping columns and constraints , reassigning partitions , or disabling or enabling constraints and triggers 通过更改、添加或删除列和约束,重新分配分区,或者启用或禁用约束和触发器,从而修改表的定义。
You can use the drop existing clause to rebuild the index , add or drop columns , modify options , modify column sort order , or change the partition scheme or filegroup 可使用drop _ existing子句重新生成索引、添加或删除列、修改选项、修改列排序顺序或更改分区方案或文件组。
Changes that affect all the rows in very large tables , such as dropping a column or adding a not null column with a default , can take a long time to complete and generate many log records 影响超大型表中所有行的更改,比如删除列或者用默认值添加not null列,可能需要较长时间才能完成,并将生成大量日志记录。
After a publication is created , you can use column filtering to drop a column from an existing publication , but retain the column in the table at the publisher , and also to include an existing column in the publication 创建发布后,可以使用列筛选从现有发布中删除列,但在发布服务器中的表中保留该列,也可以在发布中包括现有列。