Schema Element for EventClass (ADF)

Contains elements that define event class fields.

Syntax

<EventClasses>
    <EventClass>
        ...
        <Schema>

Element Characteristics

Characteristic	Description
Data type	None.
Default value	None.
Occurrence	Required once per EventClass element.
Updates	Cannot be added or deleted when updating the application.

Element Relationships

Relationship	Elements
Parent element	EventClass Element (ADF)
Child elements	Field Element for EventClass/Schema (ADF)

Remarks

An event class schema defines an event class table in the application database. Notification Services automatically adds ID columns to this definition when creating the database table.

Example

The following example shows a Schema element that creates two event fields: a 10-character stock symbol field, and a stock price field that accepts monetary data.

<Schema>
    <Field>
        <FieldName>StockSymbol</FieldName>
        <FieldType>char(10)</FieldType>
        <FieldTypeMods>NOT NULL</FieldTypeMods>
    </Field>
    <Field>
        <FieldName>StockPrice</FieldName>
        <FieldType>money</FieldType>
        <FieldTypeMods>NOT NULL DEFAULT 10</FieldTypeMods>
    </Field>
</Schema>

See Also

Reference

Application Definition File Reference

Other Resources

Defining Core Event Class Properties
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance