通过

SubscriptionFieldCollection.Add Method (SubscriptionField)

  • 项目

Adds a SubscriptionField at the end of the SubscriptionFieldCollection object.

命名空间: Microsoft.SqlServer.Management.Nmo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub Add ( _
    subscriptionField As SubscriptionField _
)

public void Add (
    SubscriptionField subscriptionField
)

public:
void Add (
    SubscriptionField^ subscriptionField
)

public void Add (
    SubscriptionField subscriptionField
)

public function Add (
    subscriptionField : SubscriptionField
)

参数

备注

If you add a field to a deployed application, updating the instance re-creates the subscription class to which it corresponds. A new subscription table is created, and the existing subscription tables are renamed by appending "Old" to the table names. Existing subscription table indexes are left unchanged.

Use the Update method to update the instance.

示例

The following examples show how to define a subscription field and add it to the end of the collection of subscription fields:

// Define a SubscriberLocale field that cannot be NULL
// Add the field to the end of the field collection
SubscriptionField subLocale = 
    new SubscriptionField(flightSubscriptions, "SubscriberLocale");
subLocale.Type = "nvarchar(10)";
subLocale.TypeModifier = "not null";
flightSubscriptions.SubscriptionFields.Add(subLocale);

' Define a SubscriberLocale field that cannot be NULL
' Add the field to the end of the field collection
Dim subLocale As SubscriptionField = _
    New SubscriptionField(flightSubscriptions, _
    "SubscriberLocale")
subLocale.Type = "nvarchar(10)"
subLocale.TypeModifier = "not null"
flightSubscriptions.SubscriptionFields.Add(subLocale)

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

SubscriptionFieldCollection Class
SubscriptionFieldCollection Members
Microsoft.SqlServer.Management.Nmo Namespace

其他资源

定义订阅架构
Field Element for Schema/Fields (ADF)