IndexSqlSchema Element for EventClass (ADF)
Contains Transact-SQL statements for creating one or more indexes on an event table.
구문
<EventClasses>
<EventClass>
...
<IndexSqlSchema>
Element Characteristics
Characteristic | Description |
---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Optional once per EventClass element. |
Updates |
Can be added and deleted when updating the application. |
Element Relationships
Relationship | Elements |
---|---|
Parent element |
|
Child elements |
주의
![]() |
---|
If you add or delete an IndexSqlSchema element, updating the application deletes and re-creates the event class to which it corresponds. This includes dropping and re-creating the SQL Server tables and indexes used by this event class. Any data existing in the original SQL Server tables is permanently deleted. |
예
The following example shows how to create an index named StockIndex on the StockSymbol field of the StockEvents table in the application database.
<IndexSqlSchema>
<SqlStatement>
CREATE INDEX StockIndex
ON StockEvents (StockSymbol)
</SqlStatement>
</IndexSqlSchema>
참고 항목
참조
Application Definition File Reference
관련 자료
이벤트 클래스에 대한 인덱스 정의
인스턴스 및 응용 프로그램 업데이트