Fields Element for Schema (ADF)

Provides a location for all of the noncomputed notification field definitions for one notification class.

Syntax

<NotificationClasses>
    <NotificationClass>
        ...
        <Schema>
            <Fields>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Optional once per Schema element.

Updates

Can be added and deleted when updating the application.

Element Relationships

Relationship Elements

Parent element

Schema Element for NotificationClass (ADF)

Child elements

Field Element for Schema/Fields (ADF)

Remarks

If you update a Fields element, updating the application deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the SQL Server tables used by this notification class. All data in the existing SQL Server tables is permanently deleted.

Example

The following example shows how to define notification fields for a stock application. The StockSymbol field is used to determine which notifications are grouped for digest delivery.

<Fields>
    <Field>
        <FieldName>StockSymbol</FieldName>
        <FieldType>char(10)</FieldType>
        <DigestGrouping>true<DigestGrouping>
    </Field>
    <Field>
        <FieldName>StockPrice</FieldName>
        <FieldType>money</FieldType>
    </Field>
</Fields>

See Also

Reference

Application Definition File Reference
DigestGrouping Element for Field (ADF)

Other Resources

Defining the Notification Schema
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance