SubscriptionFieldCollection.Add Method (SubscriptionField)

Adds a SubscriptionField at the end of the SubscriptionFieldCollection object.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
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
)

Parameter

subscriptionField
The SubscriptionField to add to the collection.

Hinweise

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.

Beispiel

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)

Threadsicherheit

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.