Schema Element for EventClass (ADF)

  • Article

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