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