SubscriptionField Constructor (SubscriptionClass, String)

Initializes a new instance of the SubscriptionField class with a SubscriptionClass object and a name.

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Sub New ( _
    subscriptionClass As SubscriptionClass, _
    name As String _
)

public SubscriptionField (
    SubscriptionClass subscriptionClass,
    string name
)

public:
SubscriptionField (
    SubscriptionClass^ subscriptionClass, 
    String^ name
)

public SubscriptionField (
    SubscriptionClass subscriptionClass, 
    String name
)

public function SubscriptionField (
    subscriptionClass : SubscriptionClass, 
    name : String
)

參數

• subscriptionClass
  The parent SubscriptionClass object for the subscription field.

• name
  A String, between 1 and 128 characters in length, that specifies the name of the subscription field.

  You cannot change the name. To rename a subscription field, remove the field and then add a new subscription field that has the new name.

備註

You must set the Type property. Setting the TypeModifier property is optional.

Field names must start with a letter or underscore character and can contain letters, numbers, and the characters _, #, @ and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see 識別碼.

重要事項：
You cannot name a subscription field Created, Enabled, SubscriberId, SubscriptionId, or Updated. Microsoft SQL Server 2005 Notification Services already uses these field names internally.

If you update the name, updating the application re-creates the subscription class to which it corresponds. Notification Services renames the existing subscription tables by appending "Old" to the table name and then creates new tables. Existing subscription table indexes are left unchanged.

If you want to transfer data between the old and new subscription tables, it must be done manually. For more information, see 更新應用程式.

範例

The following examples show how to define a subscription field and add it to the subscription schema:

// 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)

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

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

其他資源

定義訂閱結構描述
FieldName Element for SubscriptionClass/Schema/Field (ADF)