다음을 통해 공유


SqlSchema Element for SubscriptionClass/Chronicles/Chronicle (ADF)

Contains the Transact-SQL statements that define a subscription chronicle table.

구문

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <Chronicles>
            <Chronicle>
                ...
                <SqlSchema>

Element Characteristics

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Required once per Chronicle element.

Updates

Cannot be added or deleted.

Element Relationships

Relationship Elements

Parent element

Chronicle Element for SubscriptionClass/Chronicles (ADF)

Child elements

SqlStatement Element for SubscriptionClass/Chronicles/Chronicle/SqlSchema (ADF)

주의

A SqlSchema element defines one or more SqlStatement elements.

When using a subscription chronicle you should include one SqlStatement element that drops or renames the chronicle table if it already exists, and one SqlStatement element that creates the chronicle table. If you do not drop or rename an existing chronicle table, you will receive an "object exists" error when you update the application.

If you want to keep your subscription chronicle data when updating your application, you can comment out the CREATE TABLE statement in your application definition file (ADF) after you create the application.

The following example shows how to drop an existing subscription chronicle table named StockSubscriptionChron, and then create the subscription chronicle table. The table contains three columns, SubscriberID, StockSymbol, and StockPrice.

<SqlSchema>
    <SqlStatement>
    IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
    WHERE TABLE_NAME = &apos;StockSubscriptionChron&apos;)
    DROP TABLE StockSubscriptionChron;
    </SqlStatement>
    <SqlStatement>
    CREATE TABLE StockSubscriptionChron
    (
    SubscriberId bigint,
    StockSymbol char(10),
    StockPrice money
    PRIMARY KEY (SubscriberId)
    );
    </SqlStatement>
</SqlSchema>

참고 항목

참조

Application Definition File Reference

관련 자료

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

도움말 및 정보

SQL Server 2005 지원 받기