다음을 통해 공유


Chronicle Element for EventClass/Chronicles (ADF)

Provides a location for specifying information about one event chronicle table.

구문

<EventClasses>
    <EventClass>
        ...
        <Chronicles>
            <Chronicle>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Required once or more within a Chronicles element.

Updates

Can be added and deleted when updating the application.

Element Relationships

Relationship Elements

Parent element

Chronicles Element for EventClass (ADF)

Child elements

ChronicleName Element for EventClass/Chronicles/Chronicle (ADF)

SqlSchema Element for EventClass/Chronicles/Chronicle (ADF)

주의

Event chronicles are optional; use the Chronicle element and its child elements only if you need to maintain event information outside of the event tables used by an event class. A common reason to use event chronicles is to store and maintain event data for scheduled subscriptions. For more information, see 이벤트 클래스에 대한 기록 정의.

ms146596.note(ko-kr,SQL.90).gif중요:
If you delete a Chronicle element, updating the application deletes and re-creates the event class to which the chronicle corresponds. This includes dropping and re-creating the Microsoft SQL Server tables and indexes used by the event class.

The following example shows a Chronicle node that deletes any existing table named StockEventChon and then creates the StockEventChron event chronicle table.

<Chronicle>
    <ChronicleName>StockEventChron</ChronicleName>
    <SqlSchema>
        <SqlStatement>
        IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES
            WHERE TABLE_NAME = &apos;StockEventChron&apos;)
        DROP TABLE StockEventChron
        </SqlStatement>
        <SqlStatement>
        CREATE TABLE StockEventChron
        (
        StockSymbol char(10),
        StockHighPrice money
        PRIMARY KEY (StockSymbol)
        )
        </SqlStatement>
    </SqlSchema>
</Chronicle>

참고 항목

참조

Application Definition File Reference

관련 자료

이벤트 기록 테이블 정의
이벤트 클래스에 대한 기록 정의
인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기