SubscriptionFieldCollection.Add Method (SubscriptionField)

Статья
12/15/2008

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
)

Параметры

subscriptionField
The SubscriptionField to add to the collection.

Замечания

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Другие ресурсы

Определение схемы подписок
Field Element for Schema/Fields (ADF)

Поделиться через