Partager via


FieldName Element for SubscriptionClass/Schema/Field (ADF)

Specifies the user-defined name of the subscription field.

Syntaxe

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

Element Characteristics

Characteristic Description

Data type

string, between 1 and 128 characters in length.

Default value

None.

Occurrence

Required once per Field element.

Updates

Can be modified, but not added or deleted, when updating the application.

Element Relationships

Relationship Elements

Parent element

Field Element for SubscriptionClass/Schema (ADF)

Child elements

None.

Notes

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 Identificateurs.

ms145387.note(fr-fr,SQL.90).gifImportant :
You cannot name a subscription field Created, Enabled, SubscriberId, SubscriptionId, or Updated. SQL Server 2005 Notification Services already uses these field names internally.

If you update a FieldName element, 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 Mise à jour d'une application.

Exemple

The following example shows a FieldName element.

<FieldName>SubscriberLocale</FieldName>

Voir aussi

Référence

Application Definition File Reference

Autres ressources

Définition du schéma d'abonnement
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005