Compartilhar via

SubscriptionFieldCollection.Add Method (SubscriptionField)

  • Artigo

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
)

Parameters

Remarks

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.

Example

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)

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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

Other Resources

Defining the Subscription Schema
Field Element for Schema/Fields (ADF)