次の方法で共有


ReplicationAddColumn Method

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The ReplicationAddColumn method adds a column to a table published in one or more publications.

構文

object
.ReplicationAddColumn(
ColumnName
,
TypeText
,
PublicationName
,
[
SchemaChangeScript
]
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • ColumnName
    Name of the column to be added. The column is added to the table if the method succeeds, regardless of what is specified in PublicationName.
  • TypeText
    String containing the syntax that follows the column_name parameter in the ALTER TABLE statement in Transact-SQL.
  • PublicationName
    String naming publications to which the column is to be added.
  • SchemaChangeScript
    Optional string that specifies a schema change script to propagate to the subscriber. Valid for transactional replication only. Default is NULL.

Prototype (C/C++)

HRESULT ReplicationAddColumn(
SQLDMO_LPCSTR pszColumnName,
SQLDMO_LPCSTR pszTypeText,
SQLDMO_LPCSTR pszPublicationName
SQLDMO_LPCSTR pszSchemaChangeScript);

解説

ReplicationAddColumn adds the column specified by the ColumnName parameter to the table represented by the ReplicationTable object, and to publications specified by the PublicationName parameter. If PublicationName is set to 'all', the column is added to all publications. If PublicationName is set to 'none', the column is not added to any publication. Otherwise, set PublicationName as a string that names publications in the format '[pub1],[pub2],[pub2]'.

ms138403.note(ja-jp,SQL.90).gifメモ :
If an application calls ReplicationAddColumn on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

ReplicationTable2 Object

参照

関連項目

ReplicationDropColumn Method

その他の技術情報

パブリケーション データベースでのスキーマの変更

ヘルプおよび情報

SQL Server 2005 の参考資料の入手