Field Element for SubscriptionClass/Schema (ADF)

Provides a location for defining one subscription class field.

Syntax

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <Schema>
            <Field>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Required once or more per Schema element.

Updates

Can be added and deleted when updating the application.

Element Relationships

Relationship Elements

Parent element

Schema Element for SubscriptionClass (ADF)

Child elements

FieldName Element for SubscriptionClass/Schema/Field (ADF)

FieldType Element for SubscriptionClass/Schema/Field (ADF)

FieldTypeMods Element for SubscriptionClass/Schema/Field (ADF)

Remarks

Notification Services automatically adds SubscriberID, Created, Updated, and Enabled fields to the subscription class schema.

If you add or delete a Field, updating the application re-creates the subscription class to which it corresponds. A new subscription table is created, and the existing subscription table is renamed to SubscriptionTableNameOld. 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 Updating an Application.

Example

The following example shows the definition of a SubscriberLocale subscription field.

<Field>
    <FieldName>SubscriberLocale</FieldName>
    <FieldType>nvarchar(10)</FieldType>
    <FieldTypeMods>NOT NULL</FieldTypeMods>
</Field>

See Also

Reference

Application Definition File Reference

Other Resources

Defining the Subscription Schema
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance